4

I've had a look around on google but have only been able to find formulae for checking whether or not a cell contains a given piece of text, however what I'm looking for is slightly different.

I would like to search one column for a cell containing a given string. Then if I find it, I would like to use a value in the next-door cell on the same row.

For example, I could want to search Column A for any cell containing the word "yellow". If cell A17 contains the word "yellow", I want to output the contents of cell B17.

Would anyone be able to give me a function that does this, instead of a simple boolean True/False search?

Cheers

1
  • Hey @Tom ,, are U looking for Cell address of the Cell value to return, since Title of the question is different than text below !! Apr 6, 2020 at 6:10

1 Answer 1

3

Try:

=INDEX(B:B,MATCH("yellow",A:A,0))

enter image description here

3
  • That's great, works perfectly! Thanks a lot
    – Tom
    Apr 5, 2020 at 14:49
  • @Tom you are quite welcome Apr 5, 2020 at 14:51
  • VLOOKUP would do this as well. In the example above, =vlookup("yellow", A:B, 2).
    – guyiac
    May 21, 2023 at 21:45

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .