Match return #NA ...though item exists!
Hi Bob,
Thanks a lot ...A1 was a text value!
Solved it: =MATCH(--A1;DBLIST;0)
BTW:
From your excellent white paper "Sumproduct".
I always understood that the "evaluation arrays" should be all rows or
all columns ... or bypassing this issue via the "transpose"-function.
I tried underneath, but it returns: #NA
{=SUMPRODUCT((E2:N2=TRANSPOSE(B8:B10))*(E6:N6))}
This function though, works ...
=SUMPRODUCT((E2:N2=B8:B10)*(E6:N6))
I am a bit puzzled by this ...as it is exactly the opposit of what the
paper says!
Where am I wrong in my reasoning?
Brgds Sige
|