Hi
I guess one can do it this way to lookup multiple sheets

sheet1

AB1001 200
AB1002 300

sheet2

BC1001 500
BC1002 400

sheet3

CD1001 600
CD1002 700

The formula will be

=IF(OR(sheet1!A1:A2=A1),VLOOKUP(A1,sheet1!A1:B2,2, FALSE),IF(OR(sheet2!A1:B1=A1),VLOOKUP(A1,sheet2!A1 :B2,2,FALSE),IF(OR(sheet3!A1:A2=A1),VLOOKUP(A1,she et3!A1:B2,2,FALSE),"")))

Hope this helps.

Thanks,
Shail


Gord Dibben wrote:
Sue

From here we can't see your data or your formula.

Could you paste a sample of your data and formula(s) that "don't work"?


Gord Dibben MS Excel MVP

On Fri, 8 Dec 2006 10:04:00 -0800, Sue wrote:

I have three different worksheets and I am trying to use IF and LOOkUP
formulas to search two of the three worksheets for a specific result... I was
just using the LOOKUP function when I had just one worksheet to look at, but
now I want it to search two worksheets and thought using the if with the
lookup but... but the logical test is returning a "false" result even though
it found the correct result.