| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using INDIRECT
I'm trying to use INDIRECT for the first time. I have successfully
used it on its own e.g. =INDIRECT("'file_"&A1&".xls]sheet1'!B2") I'm now trying to use it with VLOOKUP, but Im not too should what the order of syntax was? e.g. =VLOOKUP(C3, INDIRECT("'file_"&A1&".xls]sheet1'!B2:F10"), 3, FALSE) Thanks for your input. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using INDIRECT
Shouldn't it be
=VLOOKUP(C3, INDIRECT("'[file_"&A1&".xls]sheet1'!B2:F10"), 3,FALSE) -- __________________________________ HTH Bob "AMaleThing" wrote in message ... I'm trying to use INDIRECT for the first time. I have successfully used it on its own e.g. =INDIRECT("'file_"&A1&".xls]sheet1'!B2") I'm now trying to use it with VLOOKUP, but Im not too should what the order of syntax was? e.g. =VLOOKUP(C3, INDIRECT("'file_"&A1&".xls]sheet1'!B2:F10"), 3, FALSE) Thanks for your input. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| INDIRECT.ext | Excel Discussion (Misc queries) | |||
| INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
| indirect | Excel Worksheet Functions | |||
| sum() using indirect() | Excel Programming | |||
Linear Mode
