I have an Excel worksheet with a master list of 728 supply items (e.g. pens, paper, etc.), each with their corresponding Item Type, Vendor, Subitem type, Item Number, Minimum Quantity, etc. The master list is grouped by Item Type and sub-grouped by Vendor to simplify reordering. I'm looking for an index/match array formula to use in a second worksheet so I can display the same data grouped by Subitem type (ideally not in alphabetical order, but in an order specified by a column of SubItem types on a different worksheet). I don't want to use VBA and I want the second worksheet to automatically update when I add an item to the master list. I know that sounds like a tall order, but I thought I'd ask anyway:). I've uploaded the master list.