| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specific use of INDIRECT inside VLOOKUP...
Self resolved:
= IF( ISERROR( VLOOKUP($A16,INDIRECT("'[NEW FNO EOD Data.xls]"&H $3&"'!$B$2:$Z$500"), 8, FALSE) ), 0, VLOOKUP($A16,INDIRECT("'[NEW FNO EOD Data.xls]"&H$3&"'!$B$2:$Z$500"), 8, FALSE) ) .....as easy as that. Thanks anyway to group. - KA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDIRECT(ADDRESS) inside a VLOOKUP | Excel Worksheet Functions | |||
| Indirect(NamedRange) inside Sumproduct | Excel Worksheet Functions | |||
| Indirect inside a vlookup | Excel Worksheet Functions | |||
| Indirect address inside "" | Setting up and Configuration of Excel | |||
| highlight/color cells with specific character inside | Excel Worksheet Functions | |||
Hybrid Mode
