INDIRECT function within VLOOKUP table

[Hambone70]

I have a simple VLOOKUP table in cells C1:D8 on Master, and I have manually inputted the desired sheet name in the VLOOKUP. However, I want to use INDIRECT to choose which worksheet from which to draw the data. So if I put Sample in A1 and 12345 in A2 on the Master page, the VLOOKUP looks at sheet Sample 12345, and if I put Test in A1 and 67890 in A2, the VLOOKUP looks at sheet Test 67890.

In the attached sample, the sheet name used in the VLOOKUP needs to come from cells A1 and A2 on the Master page, and the sheet name needs a space between the values in A1 and B1. (Cell A12 on Master is my attempt to concatenate the INDIRECT sheet name.)

Any help appreciated!

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Jacc]

Like this?

Please Login or Register  to view this content.

[Hambone70]

Perfect.

Thanks, guys!

[TMS]

You're welcome.