software

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.

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

=INDEX(C:C ,MATCH(quot;stringquot;,E:E,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Box815quot; gt; wrote in message
...
gt; I've seen this function but just can't find it again.
gt;
gt; How do I get a cell to take the value of a cell 2 cells to the left of a
gt; cell with a specific value. For example, I want a cell to take the value
of
gt; a cell 2 cells to the left of a cell with a unique text string.