Multiple Lookup Value in VLOOKUP ?

[Vinns]

Hi,
I would like to know if it's possible to make a VLOOKUP
fonction with a multiple lookup Value ?
For example, in sheet1 :
A B C 5
A B E 8
B E F 2
C F G 3

in a cell i would like to return the number in the 4th
column with the criteria A B E
Any Idea ?
Thanks
Vinns

 

[Govind]

Hi,

Try using

=SUMPRODUCT((A1:A4="A")*(B1:B4="B")*(C1:C4="E")*D14)
(This will however sum up if there are more than one rows matching this
criteria)

or

=INDEX(A14,MATCH(1,(A1:A4="A")*(B1:B4="B")*(C1:C4="E"),0),4) - To be
entered with Ctrl+shift+Enter

assuming that your data range is between A1 to D4

Regards

Govind.

 

[vinns]

Thanks
It's work fine.

-----Original Message-----
Hi,

Try using

=SUMPRODUCT((A1:A4="A")*(B1:B4="B")*(C1:C4="E")*D14)
(This will however sum up if there are more than one rows matching this
criteria)

or

=INDEX(A14,MATCH(1,(A1:A4="A")*(B1:B4="B")* (C1:C4="E"),0),4) - To be
entered with Ctrl+shift+Enter

assuming that your data range is between A1 to D4

Regards

Govind.


.