I've been trying to combine a vlookup function with a sumif function
for weeks now, however, without success.

This is my problem. Instead of looking up a single value, i.e.
=vlookup(A1, rang, 4, false), I like to do this for an entire range
and suming up that range. Something like this:
1 2 3 4 5 6
Table 1 10€ 35€ 50€ 23€ 60€ 50€
Jack 10€ 35€ 50€ 23€ 60€ 50€
Brian 10€ 35€ 50€ 23€ 60€ 50€
Juergen 10€ 35€ 50€ 23€ 60€ 50€
Feff 10€ 35€ 50€ 23€ 60€ 50€

So, I like to look-up the sum of these value without suming up these
values in table 1 and doing a vlookup on the sum.

Table 2

Feff
Juergen
Jack

I think the formula should look something like
this...=(sum(if(vlookup(Table2'A1;range;1;false)=T able2'A1;sum(range)))...I
really have no idea how excel can choose the particular row to sum up
the value. I hope this is not too confusing to you. I figured I'd
write it in English rather than German as more user can help me out on
this. I really appreciate any help. thanks you!!!