Dropdown Vlookup / Hlookup across multiple tabs

[davidfrommke]

Hello all - I am in need of assistance on something.

I have a spreadsheet where I am attempting to use a dropdown menu along with a vlookup formula.

I have 5 or more tabs in an excel workbook and attempting to pull data from the different tabs into one special tab that shows the data.

However, I am not able to figure out how to do that so when I change from one item (GM to Chrysler, ford,etc) that it switches from the one tab to another tab.

Any help would be appreciated.
Thank you.
dave

 

[jasonb75]

It's not entirely clear what ranges are to be used in the formula from your description and screen capture but it looks like you need to use the INDIRECT function.

As an example

=VLOOKUP($B4,Chrysler!$A$2:$B$20,2,0)

would become something like

=VLOOKUP(B4,INDIRECT("'"&$A4&"'!A2:B20"),2,0)