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

  • Thread starter Thread starter artisdepartis
  • Start date Start date
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
 
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
|
 
You must log in or register to reply here.

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
Runtime error 1004 when trying to insert formula in cells 11
VLOOKUP 2
VLOOKUP cell Address 3
Formula to Find Max in a Row and Return Column Title 4

Back
Top