Function to return value from each tab

[Steven Leuck]

I used to know how to do this. Can't seem to figure it out now.
I would like an entry on my first spreadsheet tab to look up the same cell
reference on each spreadsheet tab depending on my entry. Then entry would be
the same as the tab name.
Example: I have tabs named E1, E3, E5, E8, E9. If I imput "E1" into cell
C4 on my first tab I would like cell g3 (also on my first tab) to tell me
what is in cell c3 on the tab named "E1". Likewise, if change my entry to
"E5", I would like cell G3 on my first tab to tell me what is in cell C3 on
tab E5.

I used to use =IF statements to do this with. But, Excel only allows 7
nested =if statements and I have more tabs than that.

Help is VERY appreciated.
Steven Leuck

 

[Biff]

Hi!

Try this in cell G3:

=IF(C4="","",INDIRECT(C4&"!$C$3"))

Biff