I have a list of data in a different worksheet, and if I use vlookup ie.

=VLOOKUP(AA4,'Dump'!$A$1:$DB$151,91,FALSE) -

It brings back a value, however if I use Sumproduct

=SUMPRODUCT('Dump'!CQ3:CQ101=Holdings!AA5)*('Dump'!CL3:CL101)

It brings back 0, does anyone know why this is?

The reason I need to use sumproduct is because some IDs have more that 1 row
of data, so I need to sum it.

Thanks in advance for any help/ideas.