| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Lookup cell address
Is there a way to get vlookup to return the address
instead of the value of a cell. I can do this w/o VBA using the function =CELL("address",INDEX(C71:D74,MATCH("b",C71:C74),2 )) but the CELL function is not in the WorksheetFunction object. Thanks in advance for any help with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Cell Address | Excel Worksheet Functions | |||
| LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Lookup, and Return Cell Address | Excel Worksheet Functions | |||
| V Lookup and return cell address | Excel Worksheet Functions | |||
Threaded Mode
