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.

--


Gary


"Bernd Plumhoff" wrote in message
...
=INDIRECT(B4 & "!E32")

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

if B4 includes a name with blanks in it.

HTH,
Bernd