Yes, you can. It would be impossible for me to try to explain it here and
in fact the only way I can make sense of the process is with the workbook
open and the comprehensive e-mail explanation Peo sent me.

The example workbook he sent me looks across eight worksheets. It makes
some sense if you study it.

Here are a couple formulas that both do the same thing. In the first
formula Peo named the sheets list MySheets and in the second inserted the
sheet names individually. Much longer formula of course. Perhaps you can
adapt the second one to your needs or make a list of your worksheets and
name them and adapt the first formula to suit.

=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)

If you like I can send it to you the workbook.

HTH
Regards,
Howard

"J@Y" wrote in message
...
Is there a way to use Vlookup or something like Vlookup to search multiple
worksheets?