formula help please

[Gary Keramidas]

i want to write a formula, not vb, using a value in a cell to reference
that sheet name.

on a summary sheet i list the names in column b4, Kim in this example.

in column c4, this formula would give me the value i need from kim's sheet,
=Kim!$E$32

so if i have Kim entered in column B, what would the formula be to use the
name in B4 in the formula ?

tried a few options like =B4 & "!$E$32, = indirect(b4)!$E$32 but nothing
worked

 

[Bernd Plumhoff]

=INDIRECT(B4 & "!E32")

or INDORECT("'" & B4 & "'!E32")

if B4 includes a name with blanks in it.

HTH,
Bernd

 

[Gary Keramidas]

thanks, i was on the right track, just didn't hit on the right combination.
i thought i even tried that one, but i guess not.