View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dawgfan dawgfan is offline
external usenet poster
 
Posts: 3
Default VLOOKUP - columnar sheet with multiple matches - need to return a

I have a huge spreadhset (and a deadline!) that VLOOKUP will find several
matches for the lookup_value. Each may have a diferent value at the
range_lookup. I need the formula to return a sum of all values. Please help
me figure out how to do it! Thanks very much!