Hi,
I have multiple order sheets where i want to collate the totals in one summary sheet so i know the total orders per item.
is there a multiple vlookup function i can do. I want to summarise column D with the items in Column A.
Thanks
I have multiple order sheets where i want to collate the totals in one summary sheet so i know the total orders per item.
is there a multiple vlookup function i can do. I want to summarise column D with the items in Column A.
A | B | C | D | |
1 | Product | Recommended Retail Price | Wholesale price (excl VAT) | Quantity |
2 | 123 | 10 | ||
3 | 456 | 20 |
Thanks