help using LOOKUP to find vlaues on another worksheet

G

glw

Joined
Mar 17, 2006
Messages
7
Reaction score
0
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?
 
Last edited:
bump...

is this question really that hard? i'm no excel wizard but it seems like it would be fairly easy for an insider!
 
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)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help using LOOKUP to find vlaues on another worksheet 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Vlookup - Multiple Sheet HELP PLEASEEEEEEEEE 2
use cell text in lookup function 3
Lookup / Summary Table 8
Naming non-contigent cells with vba 5
Join Excel Cell within 1 Worksheet to another 2
Help with an IF Formula 1

Back
Top