Variable Worksheet Name in Formula

[pdberger]

Good morning --

I have a workbook storing similar data on multiple worksheets. I have a
'Report' page, from which I'd like to abstract the right person's data onto a
jpeg form and print it out. I'd like to be able to put the person's name in
a cell at the top of the page, and have formulas extract the data from the
associated worksheet.

So, if I have worksheets labeled 'Smith', 'Jones', and 'Wesson', on the
'Report' sheet I'd like to put 'Smith' in, say, cell B1 and have a formula
pick up that value and go to the 'Smith' page to pull in the info from, say,
cell C50.

Is that possible without VBA code?

TIA

 

[Gary''s Student]

=INDIRECT(B1 & "!C50")

 

[pdberger]

Gary's Student --

Grasshopper, you are a student no longer! Many thanks. Saved me DAYS of
work.

(If you're too young for the 'grasshopper' reference -- congrats, and I can
let you know where it's from...)

peter

 

[T. Valko]

Try this:

=IF(B1="","",INDIRECT("'"&B1&"'!C50"))

 

[L. Howard Kittle]

He's selling Yellow Book ads now...lol
Regards,
Howard