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

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.

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

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)

"Box815" wrote in message
...
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.