VLOOKUP different worksheets based on formula

[lucaduc]

Hi, I have a workbook with multiple tabs. In my master sheet I have values in column A (AA, BB, CC, DD, EE....for example). Then I have tabs labeled AA, BB, CC, DD, EE. I'm trying to do the same vlookup based on cell B but on different tabs depending on what my master sheet column A value has...

So if Column A is BB I want the vlookup to look at sheet BB. Here is the manual way of doing it:

=VLOOKUP(B1,BB!A:B,2,FALSE)

Here is what i want the formula mimic so it works in a similar fashion:

=VLOOKUP(B2,A2&"!A:B",2,FALSE)

I also tried giving A:B on sheet BB a reference of 'BB' in hopes this would work:

=VLOOKUP(B2,A2,2,FALSE)

Any help is appreciated!!!

[Jonmo1]

Try

=VLOOKUP(B2,INDIRECT("'"&A2&"'!A:B"),2,FALSE)

[lucaduc]

Thank you!

[Jonmo1]

You're welcome.