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
Thanks
Bookmarks