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.