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>