VLOOKUP over multiple sheets

skjolsc

New Member
Joined
Jul 25, 2013
Messages
6
What I am trying to do is take a certain SKU, then return the text located in the 18th column associated with the SKU. The search for the SKU is over around 30 different worksheets with around 200 to 4000 lines on each sheet. SKUs will be repeated many times throughout, but this column should always be the same so any occurence in which it might happen is ok.

I have this formula:

{=VLOOKUP(C3,INDIRECT("'"&INDEX(SheetList,MATCH(TRUE,INDIRECT("'"&SheetList&"'!A2:A4005"),C3)>0,0)&"'!R2:R4005"),18,FALSE)}

But I am thinking there is a way to do this that will actually work.

Thanks ahead of time!
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,123,367
Messages
5,601,214
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top