I think vlookup is the function

OK, I can't seem to figure this out. I have a wedding list of guests and want to figure out seating assignments. Here is my data


A B C D E
Name Qty Table # Tables
johnson 2 1 Table 1
wilson 3 3 Table 2
taylor 2 3 Table 3
sherman 1 2 Table 4
blackburn 2 2
adams 2 1
hunter 2 4
paulson 2 2


So i would like the formula to determine for column E (in this example) that table 1 has 6 guests, table 2 has 5 guests

Thank you for your help!