Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help please
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 -- Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help please
=INDIRECT(B4 & "!E32")
or INDORECT("'" & B4 & "'!E32") if B4 includes a name with blanks in it. HTH, Bernd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help please
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |