Search a string of cells in a row, and return the contents of an adjacent cell


I want to be able to search a number of non-contiguous cells in a row to find a certain value, then return the contents of the cell immediately to the left of the cell that contains the value.

I know there has to be a way to do this, but I can't figure it out.

Thanks in advance,



Best Answer