INDIRECT to a range to return a specific cell

[brooksc29]

I'm designing an excel workbook that where the first sheet (called PRINT) will reference the rest of the data sheets based on a drop down box in cell A2. The drop down box uses a list that corresponds to separate sheets and the data on those sheets, based on the name of the sheet.

In cell B1 on PRINT, I'd like to return the value in cell B8 of the referenced sheet in the drop down box in cell A2.

For example, in A2. on PRINT the text NYM is entered, referring to the sheet NYM, and I'd like the formula in B1 to return the data in cell B8 from the NYM sheet.

Do I start with an INDIRECT(A2) then use a MATCH formula or VLOOKUP from there? I am having trouble writing the formula that will return an exact cell within a sheet that is indirectly referenced... as the drop down box will be able to change and the user will be selecting different sheets based on the name of the sheet.

Thank you in advance!

 

[steve the fish]

You just want to return what is in B8 of the sheet named in A2?

=INDIRECT("'"&A2&"'!B8")

 

[brooksc29]

thank you!