CODEWITHSUNDEEP
google-sheets
RothX
RothX

Reputation: 273

How to return the cell next to the cell that contains a string in Google Sheets?

So say I have a google spreadsheet where:

My goal then, is to make a function that returns E5.

I tried using MATCH, but that returns the number in the array, rather than the cell address. Even if it did return the cell address, I'm not sure how I would use it to find the cell next to it. Optimally, I would like this address to be returned in a way that I can input into another function. So how can I do this?

Please tell me if I can make this question more clear in any way. I'm very tired right now, so it might be worded weirdly.

Thanks in advance!

Upvotes: 0

Views: 3098

Answers (2)

ttarchala
ttarchala

Reputation: 4567

VLOOKUP() is exactly what you need, if you need the cell value of E5.

=vlookup(A1, D:E, 2, 0)

If you need the cell's address, you are probably thinking about your problem wrong - what is it exactly you want to do with the cell address?

Upvotes: 2

Max Makhrov
Max Makhrov

Reputation: 18717

There are two functions, that will be handy in this case:

  • if you want to get value from E5 then use offset
  • if you need to get "E5" as string, then use address function.

Also if you have an address like "E5" you may get the value of E5 with indirect function.

Upvotes: 1

Related Questions