Hi,

This is in continuation to Ardus's solution to my post "2 way Vlookup -
Creating array arguments as needed"

http://groups.google.co.in/group/mic...336107f3?hl=en

I would like to know as to whether it is possible to perform lookup (of
a string value) kind of operation with Sumproduct function or not.
Presently am using Shift+Ctrl+Enter along with Index but would be happy
to learn other ways as well.

Regards,
HP
India


Hari wrote:
> Ardus,
>
> I tried with
>
> =SUMPRODUCT((A1:A4=F1)*(B1:B4=G1),D1:D4)
>
> but it returns me zero which is wrong. (Note, putting semicolon between
> B1:B4=G1) and D1:D4 is not a valid formula syntax).
>
> Regards,
> HP
> India