Ok,
Sorry this took so long. I was having a terrible time until I realized that your named range "itemcode" in Basic!B2:B7
that you were using to produce the drop-down in Master!A3 does not correspond to all entries in your Dealer Data for
Item Code.
I created a new named range called Item_Code_Reference_Range in Master Column L and used it for the data validation for the input cell Master!A3. I also formatted your Dealer
Data into an Excel Table. This creates dynamic named ranges for all columns in the table.
The following formula can then be ARRAY ENTERED (Ctrl+Shift+Enter) into Master!B6 and copied down as
far as you need:
The other columns in your sorting table use the same formula only the initial array criteria for the INDEX(array) changes
to the corresponding column in Dealer Data.
Hope this helps!
Bookmarks