Hi there,
If I have a data set that contains customer names and product purchased with their price.
How can a do a lookup of that customer with the total amount purchased?
Hello - you can use the FILTER function to extract all lines relating to Bob. Just create a data validation for the list of names and then enter the following formula;
=FILTER(Range (Excluding Headers), Then Highlight Name Range = Bob (On data validation drop down). This will extract all records for Bob only and should look like;
Name
Product
Amount
Bob
Snickers
1
Bob
Pear
2.5
Bob
Orange
1
As an alternative to SUMIF,you can enter SUM(FILTER(Range (Excluding Headers), Then Highlight Name Range = Bob (On data validation drop down) which will also give you the total for Bob.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.