VLOOKUP Table Array (different Workbook) Based on Another Cell's Value

[Gian_Prakash]

Hi All,

I'm trying to VLOOKUP a value in different Workbook (could be Open or Close). However the Table Array information, I would like to get determined by the value of another cell so that in case if I have to change the lookup worksheet & its path in multiple formulas, I would have to change the value of this single cell only. Below is the example of what I mean to say:

in cell A1
=VLOOKUP(123, (cell B2 value), 2, FALSE)

in cell B2
'C:\users\abc\[test.xlsx]sheet1'$A:$B)

I have spent quite a some time on this from defining name to trying diff. permutation & combination, but couldn't succeed.

Appreciate you time & help for this

 

[arthurbr]

Perhaps INDIRECT(B2)

 

[Gian_Prakash]

I did tried INDIRECT, but unfortunately didn't worked.