In the attached excel file, how do I utilize vlookup using the unique ids to sum up the total cost of each fruit?
In the attached excel file, how do I utilize vlookup using the unique ids to sum up the total cost of each fruit?
is this what you want?
=SUMIF($A$2:$A$7,F2,$D$2:$D$7)
(not quite sure how you want teh "unique" to figure in?)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want to specifically use vlookup using the unique identifiers to find the cost associated with that id
OK so which value do you want returned...and why the insistence on using VLOOKUP (which may or may not be the function you need)?
I would like the total cost returned, for example the total cost of each apple returned in the column to the right, vlookup is just a preference to see if it can be done using the unique ids for each fruit.
Did you try my sumif function?
I did try that and that works, my problem comes when there are similar names but unique ids, for instance when using your SUMIF response it is using the names from column 1 to do sumif, what if I have something like this in the attached photo, where there a is an apple with 2 unique ids, how will you go about doing that summation.
=sumifs($d$2:$d$7,$a$2:$a$7,f2,$b$2:$b$7,g2)
Quang PT
This works, Thank you!!
Thanks for the feedback
And thanks for the assist Quang
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks