This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Disclaimer: I’m pretty drunk but I’ve been trying to fix this for days, any tips would be greatly appreciated
Hi, I want to have a function that finds the sum of multiple vlookup values, so I am trying to find a way to do this using an array as the lookup value in the vlookup. Unfortunately this is not working, and I have also tried using sumproduct and sumif, but I can't get either to work. The chart below displays what I want to do:
| Group 1 | Group 2 | Group 3 | Total |
|---|---|---|---|
| A | B | C | (D2) |
| B | E | D | (D3) |
| E | D | A | (D4) |
Let's say I have this in my workbook, and I have a separate chart that has the following:
| A | 3 |
|---|---|
| B | 5 |
| C | 1 |
| D | 10 |
| E | 6 |
I would want the D2 cell to output 9, the D3 cell to output 21, and the D4 cell to output 19. Is there a good function to use for this scenario, to find the corresponding value for each letter and then sum them up? I know I could simply do the sum of 3 separate vlookups, but I would love to know if there is any easier ways to do this function. Thanks!
Post Details
- Posted
- 3 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...