Looking up data in other worbooks

[brianfosterblack]

I have a table where I have to draw data from a number of workbooks
While the table is across multiple columns, it is between rows 2 and 201

So in cell AB2 I have this formula
=VLOOKUP($A3,[Trap12.xlsm]Squadding!$K$3:$P$202,2,FALSE)

This is the formula I tried to pick up the variable which is the workbook name in row 206 and different for each column

VLOOKUP($A3,"["&AB$206&".xlsm]Squadding!$K$3:$P$202",2,FALSE)

 

[Joe4]

You need to use the INDIRECT function to dynamically build range references.
See this link here, which even shows you how to build one to another workbook: https://www.contextures.com/xlFunctions05.html#RefWkbk

 

[brianfosterblack]

Thank you. I resolved it.

 

[Joe4]

You are welcome.