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?

VLOOKUP - search key is more than once available
 

Without an example of your data and what result you expect it is a bit hard
to visualize exactly what you need. However, it appears that you want to sum
some data based on criteria so lookup SUMIF and SUMIFS in help. They might do
what you want.

--
Regards,

OssieMac


"MCFD" wrote:

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?

VLOOKUP - search key is more than once available
 

SUMIF works perfect, Thanks!

"OssieMac" wrote:

Without an example of your data and what result you expect it is a bit hard
to visualize exactly what you need. However, it appears that you want to sum
some data based on criteria so lookup SUMIF and SUMIFS in help. They might do
what you want.

--
Regards,

OssieMac


"MCFD" wrote:

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?