Automatically use the right tab in a vlookup

[LadyHarper]

I have a spreadsheet, that needs to look up internal and external rates.

Currently I use Vlookup and tell it which tab to look for based on the project it is on. In my spreadsheet I have Column B that says the Tab reference.

Is there a Formula that I can set so it automatically uses the Vlookup in the correct tab?

=VLOOKUP($H485,'EX51'!$I$2:$S$57,11,FALSE) = the EX51 is where I am telling it what tab, looking to change that to check Cell B for the correct tab.

 

[LadyHarper]

OMG I'm so silly, the S$57 didn't cover the entire list... fixed and works thank you so much.

 

[dreid1011]

Glad you figured out the issue, and you're welcome.