Use a cells calculated value for a referance to lookup a particular sheet

[chrisrmazur]

I have a very simple spreadsheet that is working but want to make it more user friendly...not sure how to do it...

I have a multiple tab spreadsheet that has students name with account info ... description, money add, money subtract, and balance (see attached)

I then have a summery of all students on one page showing their account balance using a lookup function =LOOKUP(2,1/(Tony!D:D<>""),Tony!D:D) to indicate their running balance .

I'm using a index to list the students name (which is the same name as indicated on the Tab)

what I want to do is make sure the "tony!" tab is always showing the correct value next to the correct tab...

is there are way to reference the lookup cell to the name that is next to it....

[Pete_UK]

Try this in C3:

=LOOKUP(2,1/(INDIRECT("'"&B3&"'!D:D")<>""),INDIRECT("'"&B3&"'!D:D"))

then copy down.

Hope this helps.

Pete