Forum Discussion
match and replace
I wish to know which customer group does the most purchase in my Sales Receipt sheet However I only have customer ID on this sheet so I assume I have to match it to ID in the other sheet that has Cu...
Have a look at the XLOOKUP function in Help. It should get you there. But if you're summarizing this data you probably are better off creating a pivot table using the data model and then joining those two tables so you can drag the Baby boomer column from table A to the pivot table and the column you want to summarize from table B to the pivot table.