Hi All:
How can I get VLOOKUP to account for all items that match it, not just the first one? For example, if a PLU (Product Look Up code) is sold at 2 stores, I'd want to see the total of the 2 stores, not just the first one VLOOKUP found.
I can accomplish this using a SUMPRODUCT formula I...