Hi there,
I have stucked on Vlookup like the title.
So example: I have an Excel file contains data to be searched by Vlookup as path: D:\Example\Data.xlsx.
And I have an other Excel with cell B2 that contains value path of Excel data (D:\Example\Data.xlsx.).
What i need is dynamic that B2 cell value into my Vlookup function formula,so I really dont know is there any formula in Vlookup to solved it. I tried as below
=VLOOKUP(A3,INDIRECT(CONCATENATE(B2,"test'!$B:$L")),2,FALSE)
But it does not work. I need all your help. Thank so much.