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!

I get a result of 4 for Table 1.

Data Range

	A	B	C	D	E	F
1	Name	Qty	Table #		Tables	Qty
2	johnson	2	1		1	4
3	wilson	3	3		2	5
4	taylor	2	3		3	5
5	sherman	1	2		4	2
6	blackburn	2	2
7	adams	2	1
8	hunter	2	4
9	paulson	2	2
10	------	------	------	------	------	------

This formula entered in F2 and copied down:

=SUMIF(C$2:C$9,E2,B$2:B$9)

You're welcome. Thanks for the feedback!