I need to input a formula in column O that searches columns B through J in the same row (formula in row 3, searches row 3, formula in row 4 searches row 4, etc) for cells that match "Mary" and I need it to output the value from 2 columns to the left of where it found "Mary."
So, in row 2, I want the output of the formula to be "IVAT," because we find "Mary" in column D and two columns to the left (in column B of the same row) we find "IVAT."
In row 3, the output would be "PSDOF". In row 4, "PSDOF". And so on.
I've tried HLOOKUP and MATCH and anything I can think of but I cannot, for the life of me, figure out how to do this seemingly simple formula.
Any and all help is greatly appreciated!