VLOOKUP with multiple criteria

[Madiya]

I need to fatch a value by vlookup from 3 criteria. Here are the
details.

In my sheet FE col A has dates, B has names, C has type and E has
value.
Dates and value will change daily while name and type is constant.
Every day new row is added in the table. Hance name and type will be
repeared on daily basis.

In sheet Summary, I entered date, name and type.
I need to fatch a value from sheet FE, col E where date, type and name
matches the corresponding value in sheet FE.

Is it possible without VBA? I would prefer a solution with formulas if
possible.

Regards,
Madiya

 

[Ardus Petus]

=SUMPRODUCT((FE!A1:A999=A1)*(FE!B1:B999=B1)*(FE!C1:C999=C1),FE:E1:E999)

This works if type in col. E has a numeric value.

HTH

 

[Madiya]

Thanks Ardus.
Type in col. E has a numeric value.
I have modified the formula slightly as below but it doesn't worl and
returns zero.
=SUMPRODUCT((FE!A1:A9999=A7)*(FE!B1:B9999=B7)*(FE!C1:C9999=C7),FE!E1:E9999)

Any suggessions?

Regards,
Madiya

 

[Ardus Petus]

It should work!

If you're stuck, please send me your workbook at: (e-mail address removed)

HTH
--
AP

"Madiya" <[email protected]> a écrit dans le message de (e-mail address removed)...
Thanks Ardus.
Type in col. E has a numeric value.
I have modified the formula slightly as below but it doesn't worl and
returns zero.
=SUMPRODUCT((FE!A1:A9999=A7)*(FE!B1:B9999=B7)*(FE!C1:C9999=C7),FE!E1:E9999)

Any suggessions?

Regards,
Madiya

 

[Madiya]

Yes. It works.
Actually it was my mistake. I forgot to change the third criteria.
Many thanks.

Regards,
Madiya