| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to return the address of a cell found via VLOOKUP?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to return the address of a cell found via VLOOKUP?
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 | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to return the address of a cell found via VLOOKUP?
Works like a charm! Bedankt :-)
On Jul 6, 11:19 am, "Niek Otten" wrote: 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 ooglegroups.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 | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to return the address of a cell found via VLOOKUP?
Works like a charm! :-)
On Jul 6, 11:19 am, "Niek Otten" wrote: 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 ooglegroups.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 | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP to return Cell Address | Excel Worksheet Functions | |||
| USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
| How to get the address of the cell found our by vlookup | Excel Programming | |||
| vlookup to return cell position as to where result was found | Excel Programming | |||
| vlookup to return the cell positioning where the criteria is found | Excel Programming | |||
Linear Mode
