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

1 Answer

Try:

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

enter image description here

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy