Use MATCH() instead of VLOOKUP() to find the relative position of the cell and use the result in INDEX() to retrieve the cell to
the left

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"artisdepartis" wrote in message oups.com...
| HI. How can i return the address of a cell found via VLOOKUP?
| I want to use this in combination with OFFSET to return the value of
| the cell left of the looked up cell.
|
| TIA! AdP
|