Since you're adding them up, maybe you don't need to do the vlookup at all:

Instead of some variation of:
=sum(Allofthematchesfor(vlookup(a1,sheet2!$a$1:$b$ 10,2,false)))
(this won't work--don't waste your time)

You could use =sumproduct:

=SUMPRODUCT((Sheet2!$A$1:$A$10=A1)*(Sheet2!$B$1:$B $10))



BubBob wrote:

Does anyone know how to use vlookup to sum multiple values (numbers)
found in the same sheet? Otherwise my case is very similar to this one.

--

Dave Peterson