View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MCFD MCFD is offline
external usenet poster
 
Posts: 2
Default VLOOKUP - search key is more than once available

I am trying to total all amounts for 1 specific key in one cell.

Example:
search key is "boy" in a table. Since this key is used various in this
specific table (not sorted) the outcome of VLOOKUP should total all amounts
that match "boy".

Currently I only got the first match, but all other "boys" are ignored (not
totaled).

Does someone have the answer?