Forum Discussion
VLookup only getting first value
Hi, I created a another tab to show different projects with different costs as shown. But when I created this formual =VLOOKUP(A7,Table01[#All],2,FALSE), the individual cells only captured th...
Hi Anonymous
VLOOKUP is to find the match value. It won't calculate the sum of all matches. To calculate the sum of all matches, you can try something like this:
= SUM(IF(A$2:A$8=E2,B$2:B$8))Reference: https://www.exceldemy.com/vlookup-sum-all-matches/
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Anonymous
VLOOKUP is to find the match value. It won't calculate the sum of all matches. To calculate the sum of all matches, you can try something like this:
= SUM(IF(A$2:A$8=E2,B$2:B$8))
Reference: https://www.exceldemy.com/vlookup-sum-all-matches/
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!