Well here is the equation I use right now to vlookup in multiple sheets in a
workbook:

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

But that runs into problems when the sheets contain the same words being
looked up. So I'm thinking if there is a way to search for a Sheet name, and
then in that Sheet, perform a vlookup.

"Chip Pearson" wrote:

What exactly do you mean by "finding" a certain sheet, and by "running" a
VLOOKUP?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"J@Y" wrote in message
...
Is there a way to search through a workbook by first finding a certain
worksheet, then running a vlookup in that worksheet?

EG:
Sheets1~Sheet5
I want to find sheet2, and in sheet2, run vlookup.