View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] knox5731@gmail.com is offline
external usenet poster
 
Posts: 15
Default vlookup question

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