help using LOOKUP to find vlaues on another worksheet

[glw]

i'm using the LOOKUP function (in cell D2) to find a value (a2) on another worksheet whose name is in B2.

"=lookup(a2, b2!a1:a25, b2!b1:b25)" doesn't work!

i believe the problem is in referencing the other sheet. how do I reference the other sheet?

 

[glw]

bump... looking for some help. report is due on monday morning.

 

[glw]

bump...

is this question really that hard? i'm no excel wizard but it seems like it would be fairly easy for an insider!

 

[glw]

bump... slowly giving up hope...

 

[glw]

just in case someone else is looking for an answer...

here is what i figured out on my own...
"=IF(ISERROR(VLOOKUP(A2,INDIRECT("'" & B2 & "'!$A$1:$B$25"),2,FALSE))=TRUE,0,(VLOOKUP(A2,INDIRECT("'" & B2 & "'!$A$1:$B$25"),2,FALSE)))"

as a working replacement for
"=lookup(a2, b2!a1:a25, b2!b1:b25)"