VLOOKUP Replace Text of Array Name with New Text

[pvragel]

I have 2 spreadsheets. Spreadsheet "b" has multiple arrays defined. I want to bring values from these arrays into spreadsheet "A".

I have an existing VLOOKUP statement that accomplishes the basic purpose. Here is an example:
=VLOOKUP(E70,'Quotes+Orders_Worksheet_2018.xlsx'!NWINTLAY120,3)

The problem is that I would like to be able to replace the NWINTLAY120 array with another array, based on a value in a cell.

For example, I have a value in cell g71 that is SWINTLAY200. I want to be able to use this value and create a new VLOOKUP statement that says, for example:
=VLOOKUP(E71,'Quotes+Orders_Worksheet_2018.xlsx'!SWINTLAY200,3)

I would like to do this without the use of VBA or macros.

Any suggestions would be appreciated.

 

[JackDanIce]

What is the cell address the array name is based on? If A1, then try:

=VLOOKUP(E70,[U]INDIRECT("'Quoates+Orders_Worksheet_2018.xlsx'!"&[COLOR=#0000ff][B]A1[/B][/COLOR])[/U][COLOR=#0000ff][/COLOR],3,0)