ExcelBanter - Using INDIRECT

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using INDIRECT (https://www.excelbanter.com/excel-programming/414342-using-indirect.html)

AMaleThing

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.

Bob Phillips[_3_]

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.

All times are GMT +1. The time now is 10:03 AM.