VLookup with multiple tabs

[UBMonte]

I have a workbook with multiple brands (tab a,b,c,...). I want to create a summary sheet that will be dynamic based on the brand chosen from drop down box (brand a,b,c...) the vlookup will go to that specific brand and execute the vlookup. Any suggestions?

Thanks in advance

 

[CWatts]

=VLOOKUP(C4,INDIRECT(D3&"!A:B"),2,FALSE)

The value you're looking up is going to be C4, Cell D3 will be the result of the tab. So for my example I made a tab called Fish and a tab called Cars. Cars and Fish were part of a drop down cell, and whatever cell that was told the function to look on that tab. Good luck.

 

[T. Valko]

I have a workbook with multiple brands (tab a,b,c,...). I want to create a summary sheet that will be dynamic based on the brand chosen from drop down box (brand a,b,c...) the vlookup will go to that specific brand and execute the vlookup. Any suggestions?

Thanks in advance

Assuming that each lookup table is setup exactly the same...

A1 = some brand (sheet name)
B1 = lookup value

=VLOOKUP(B1,INDIRECT("'"&A1&"'!A:B"),2,0)