vlookup multiple work sheets

[tpkelley_no]

have a work book that has the following work sheet names:

Table, report, Ach, wire, checks and recap

Recap is where I need the vlookup formula:

=VLOOKUP(B2,Sheet3!E:E,1,)

The “B2” value will change with each row. The column and “1” will not change.

I need vlookup to read any worksheet that starts with the word “Sheet”

 

[Gimics]

Hey tpkelley_no,

Just clarifying a couple of things - at the start of your post you say your workbook as the sheet names: Table, report, Ach, wire, checks and recap

But later you ask for a formal that can "read any worksheet that starts with the word "Sheet"? Does your workbook actually have more sheets than the sheets: Table, report, Ach, wire, checks and recap?

And when you say read any worksheet - are you wanting one formula to look through every single worksheet at once? Or will there still just be one worksheet that the formula needs to look at (it just might be a different "Sheet" each time)?

 

[tpkelley_no]

the work book starts off with
Table, report, Ach, wire, checks and recap

the "Table" work sheet is a pivot table and i click certain cell that generate the work sheets. the number of work sheets can verry.

 

[tpkelley_no]

this is the formula i can up with:

=vlookup(B2,indirect("sheet"&""),!E:E,1,)