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