You can do this programmatically. Code similar to the following will help
you find the sheet you are looking for:

For each sht in thisworkbook.sheets

if sht.name = strCriteria then

'Can return sheet name to a function here.

end if

next
--
http://HelpExcel.com




"J@Y" wrote:

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.