Write an xlookup formula across worksheet name

[eechristaylor]

I have a database of data across a large amount of columns. This data is looks similar to this:

Adams-1	Adams-2	Adams-3	Adams-4	Adams-5
10	11	12	13	14

I have a cell in a spreadsheet workbook with the same name as the 1st row and I want to grab the data in the second row using the workbook name. Is this possible? I don’t want to have to enter “Adams-1”, I want it to see that name in the workbook name and use that to grab the data.

Thanks

 

[coulombevin]

Hi eechristaylor,

use this:

=INDIRECT(A1&"!A2")

Bests regards,

Vincent

 

[eechristaylor]

Hi eechristaylor,

use this:

=INDIRECT(A1&"!A2")

Bests regards,

Vincent

I don’t understand how this works?

 

[coulombevin]

Hi eechristaylor,

In the cell A1, put the name of the sheet you want to go fetch the data from, then in the cell under it, put the following formula to get the data in the cell A2 from the sheet that has its name in A1:

=INDIRECT(A1&"!A2")

Bests regards,

Vincent