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