VLOOKUP over multiple sheets

[skjolsc]

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!

 

[shyy]

check out

Excel VLOOKUP Multiple Sheets

 

[skjolsc]

check out

Excel VLOOKUP Multiple Sheets

Thank you! This worked great!