Multiple Lookup with approximate match

[Manny Singh]

Hi All,

Could you help writing the formula to create a Multiple Lookup with approximate match?

In the attached sheet, you will see the result in yellow highlighted cells, I need a formula for the same result.

Cheers,
Manny

 

[Naresh Yadav]

Hi,

pls try this one..

=INDEX($D$3:$D$14,MAX(INDEX(($A$3:$A$14=$I$4)*((ROW($A$3:$A$14)-2)),,)))

regards
Naresh

 

[Manny Singh]

Hi,

pls try this one..

=INDEX($D$3:$D$14,MAX(INDEX(($A$3:$A$14=$I$4)*((ROW($A$3:$A$14)-2)),,)))

regards
Naresh

Hi Naresh,

Thanks for response and brilliant formula, but it needs tweaking.

See attached file, the process result should be WPS-003 not WPS-004.

Thanks,
Manny

 

[John Jairo V]

Hi, to all!

Could try:
[L3] : =INDEX(D$3:D$14,MATCH(1,INDEX(($A$3:$A$14=$I3)*($B$3:$B$14>$J3)*($C$3:$C$14>$K3),),))

And drag it right and down if necessary. Blessings!

 

[Manny Singh]

Hi, to all!

Could try:
[L3] : =INDEX(D$3:D$14,MATCH(1,INDEX(($A$3:$A$14=$I3)*($B$3:$B$14>$J3)*($C$3:$C$14>$K3),),))

And drag it right and down if necessary. Blessings!

Thanks John, works perfect, much appreciated.