Array Formula for Duplication values with 3 conditions

[mageshdev]

TYPE DIA PRICE

RBH 3 200 2934

RBH 3 250 3360

RBH 5 200 3200

RBH 5 250 3791

RBH 5 300 4464

RBH 5 350 5009

RBH 7 250 4100

RBH 7 300 4751

RBH 7 350 5226

RBH 7 400 5827


Type Dia price

RBH 3 200 INDEX($H$4:$J$14,MATCH(1,(H17=$H$4:$H$14)*(I17=$I$4:$I$14),0))


I had tried various formulas for indexing the above array, as it contains duplicate value in both the columns and had to meet both conditions, due to none of the formulas are not working, please provide the solution

 

[NARAYANK991]

Hi ,


Try this :


=INDEX($K$4:$K$13,MATCH(1,(H17=$H$4:$H$13)*(I17=$I$4:$I$13)*(J17=$J$4:$J$13),0))


entered as an array formula , using CTRL SHIFT ENTER.


Narayan