Getting data from a sheet referenced by VLOOKUP

[missingsc]

Hi All,

I'm looking for help on a formula reference using VLOOKUP. I have a table which maps some project names to Sheet names, as the project names are very lengthy but the Sheet names are small enough for the tabs in Excel. Using that table and VLOOKUP, I'm looking to use the output of the VLOOKUP (which is a Sheet name) to then reference cells on that Sheet.

For example, I'm looking to do this but obviously it doesn't work and I'm looking for the right function combination that would make it work:
=VLOOKUP(A5,Project2SheetMappingTable,2)!B2

Thanks in advance!

 

[DanteAmor]

Try:

=INDIRECT("'" & VLOOKUP(A5,Project2SheetMappingTable,2,0) & "'!B2")

 

[missingsc]

This worked with a little tweak. I removed the single quotes in the INDIRECT statement and then it worked just fine. Thank you!