Instead of explaining exactly what I'm I'll just create a table and try to explain it through that.. O
So I want to compare the numbers of Table 2 to Table 1. I want to use a Vlookup of my concatenated colors and sum up all the numbers in table 2 to compare to table 1.
To further explain this.... How do i sum up all the number of RedBlue in table 2 which would be 22. I tried to you "=SUM(VLOOKUP('Table1'Redblue,'Table2'!A:A,2,FALSE)" but it just finds the first value. Not all of them and sum them together.
any help would be appreciated. If you need me to further explain then I can.. Thanks!
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
So I want to compare the numbers of Table 2 to Table 1. I want to use a Vlookup of my concatenated colors and sum up all the numbers in table 2 to compare to table 1.
To further explain this.... How do i sum up all the number of RedBlue in table 2 which would be 22. I tried to you "=SUM(VLOOKUP('Table1'Redblue,'Table2'!A:A,2,FALSE)" but it just finds the first value. Not all of them and sum them together.
any help would be appreciated. If you need me to further explain then I can.. Thanks!
Table 1
A | B |
RedBlue | 20 |
BlueRed | 5 |
YellowRed | 10 |
YellowBlue | 15 |
<tbody>
</tbody>
Table 2
A | B |
RedBlue | 12 |
RedBlue | 3 |
Redblue | 7 |
BlueRed | 2 |
BlueRed | 1 |
BlueRed | 2 |
YellowRed | 4 |
YellowRed | 6 |
YellowBlue | 6 |
YellowBlue | 8 |
<tbody>
</tbody>