How to return the address of a cell found via VLOOKUP?

A

artisdepartis

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
 
N

Niek Otten

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

| 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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup result in a message box 10
Double click fails to run the code, just selects the cell 12
sorting: cleared/null v/s "" 3
transformed vloopup 2
VLOOKUP 2
VLOOKUP cell Address 3
Programmatically identify a particular formula (VLOOKUP) in a cell 0
VBA using VLookUp 1

Top