I cannot figure out how to return the value of a cell to the left of my
reference. For example I have a table that looks like this....
A B C
1Bob 1 5
2John 2 6
3Tom 3 7
4Tim 4 8

I need to find the number 7 in column C and return the value of the cell in
column A with the same row number. Make sense? i tried something like this:
=LOOKUP(7, C1:C4, A1:A4) but that keeps returning the wrong value. also,
column A is not and cannot be sorted alphabetically.