Multiple Lookup Sheets

Good Day

I have an excel sheet witk Sheet "MAIN". On this sheet Range A1 I put in an "Item Code". I have Over 55000 Item Codes. On the same workbook I have 30 Other sheets with Data tables from SQL SERVER. I use the Item Code(s) on Sheet Main to find the data in the other SHEETS. The First 2 Letters in my Item Code tells me where to go find the rest of the data about that specific Item.

My problem is that I don't want to go create a vlookup with 30 arguments. Is there another way that I can refer to the First 2 letters of the Itemcode? ie

Please Login or Register  to view this content.

Thanks

Hi, Sniper,

maybe like this:

Formula:

Please Login or Register  to view this content.

You would not only need to pass the information of the sheetname but of the range as well so this should be adjusted if needed.

Ciao,
Holger

Hi, Sniper,

without showing your workbook only you may anwer this question. If you have given names to the used ranges in the sheets you may only pass the name of the sheet/range, if it´s not the case you should pass the ranges where to search as well.

Ciao,
Holger