=INDEX(A1:A4,MATCH(7,C1:C4,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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