| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell address from Vlookup
Is it possible when using Vlookup within VBA so that it returns the cell
address as the output rather than the cell value? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell address from Vlookup
Then you would use Match
=Address(match(Target,A1:A1000,0),1) -- Regards, Tom Ogilvy "Harry" wrote in message ... Is it possible when using Vlookup within VBA so that it returns the cell address as the output rather than the cell value? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell address from Vlookup
Not with VLOOKUP
You have to use MATCH to return the row, MATCH to return the column, and ADDRESS (with the results of the MATCH column and Row values) to return the address HTH Philip "Harry" wrote: Is it possible when using Vlookup within VBA so that it returns the cell address as the output rather than the cell value? |
| 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 | |||
| Getting a cell address from Vlookup function in a macro? | New Users to Excel | |||
| retreiving cell address of vlookup value | Excel Worksheet Functions | |||
| How do I get the cell address of a VLOOKUP reference? | Excel Worksheet Functions | |||
Linear Mode
