Value of one cell a certain number of cells away from another cell

B

Box815

I've seen this function but just can't find it again.

How do I get a cell to take the value of a cell 2 cells to the left of a
cell with a specific value. For example, I want a cell to take the value of
a cell 2 cells to the left of a cell with a unique text string.
 
B

Bob Phillips

Is it all column based, so does this work for you

=INDEX(C:C ,MATCH("string",E:E,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top