This worked for me on your data sample, returned 12.

=SUMIF(E1:E3,B1,F1:F3)

Where B1 holds A023FINV2006, which may be the result of a formula to
concatenate your two other values.

HTH
Regards,
Howard

"L. Howard Kittle" wrote in message
. ..
Hmmm,,,

Can you send me a example worksheet to look at?

Howard

"L. Howard Kittle" wrote in message
...
So the 1st match and the 2nd match are identical? If so then vlookup is
of no use. I don't know enough of the magic behind sumproduct to be of
help, sorry.

Regards,
Howard

wrote in message
oups.com...
I'm trying to write vlookup that will lookup cells in a different
worksheet. However, there are two matches on the other worksheet. How
can I get it to sum up those two matches and then put it as my value.

I'm looking for something like this but I don't know how to get it to
work with multiple matches in the vlookup

=SUM(Vlookup($A$74&"FINV"&$A$75,'Est-Inv Data'!$F:$S,D$70,FALSE))


Help?

Thanks!
knox