Hi there,

I can send you a Peo Sjoblom workbook that does that with a VLOOKUP formula.
His example does eight workbooks, but you can add to it. You would adjust
to your ranges and cells.

The formulas look like this, with the first using a named range to list the
worksheets and must be entered Ctrl +Shift + Enter, which will put curly
brackets around the formula {the formula}. It returns the 3rd column of the
lookup array, note the next to the last argument is a 3.

The second formula simply lists all the worksheets (much longer) and is
activated with Enter. It returns the 2nd column of the lookup array, note
the next to the last argument is a 2.

=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A2:A200"),A2)0) ,0))&"'!A2:C200"),3,0)

=VLOOKUP(A2,INDIRECT("'"&INDEX({"Sheet1";"Sheet2"; "Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Shee t8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3"; "Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A 2:A200"),A2)0),0))&"'!A2:C200"),2,0)

HTH
Regards,
Howard

"DILipandey" wrote in message
...
Hi Experts,

Is there any way that vlookup can lookup value from more that one tabs.
Refer following formula:-

=vlookup(A1,(Sheet2!A:B,Sheet3!A:B),2,0)

So my data is around 90,000 rows and I am using excel 2003. I want to
lookup data from Sheet 2, Sheet 3 and so on.. Sheets count may increase to
50.

Note: I have tried IF(IsError) and similar functions.. but they are
limited
in scope.

--
Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India