see your other post

--
Biff
Microsoft Excel MVP


"Alibo" wrote in message
...
From the answers you have given here I think you will e able to help me...

I am trying to get the sum of multiple returns on a VLOOKUP. As an
example:

Jan 24
Jan 57
Jan 239
Feb 72
Mar 16
Mar 44

I want to get a result that looks like:

Jan Feb Mar
320 72 60

I have tried:

=SUMPRODUCT(VLOOKUP((Jan,A2:B7,2,FALSE))

But unfortunatley that just returns 24.

Can you help?

Alibo