Xor, this formula looks like exactly what I'm needing for a project of mine. Can you please explain how it works?

I tried replacing the names with the actual array, but that seems to break the formula. For example, I replaced "d" with Services!$B$2:$B$221, and now the formula is only working for the very first example Alawa Preschool. Maybe you can shed some light on why this isn't working past the first match, even though the "d" name is only referencing the services B2 to B221.



What I'm needing is to be able to sort items in a list into various customers for a report. Right now we currently have four customers, which each have their own tabs for a report that I send them daily. So, if a list of "sales" for the day can come from any of these customers, I'm needing a formula that will only grab sales for a specific customer, and then I'd modify that customer on each tab. Something automatic instead of trying to use a filtered pivot table, which can get messy.

I'd rather learn the logic behind what is happening so I can use it for other problems as well. I just recently learned the trick of combining Index and Match for a more flexible alternative to VLookup, which looks similar to what you're doing here. I've not used the SMALL, ROW, CELL, or ROWS formulas you're using here, so would appreciate a brief tutorial of how everything is working together.

Edit mod : this post refers to https://www.msofficeforums.com/excel...t-only-if.html