You have AA4 in one formula and AA5 in another????
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"Nav" <
[email protected]> wrote in message
news:
[email protected]...
>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.
Bookmarks