I am trying to figure out how to return a value of a cell one column to the left of anywhere excel finds a reference cell in a given range. I thought the offset function would work, but it does not seem to accept a given range. Ex:
A B
1 1 a
2 2 b
3 3 c
4 4 d
Basically from a diff tab I want excel to return the value to the left of wherever it finds the value "c" in the range a1.c4.
I know this is prob very simple.
Thanks for your help!!!
A B
1 1 a
2 2 b
3 3 c
4 4 d
Basically from a diff tab I want excel to return the value to the left of wherever it finds the value "c" in the range a1.c4.
I know this is prob very simple.
Thanks for your help!!!