Index match with two conditions

[msharma864512]

Hi,

I am trying to put certain values across the columns by matching two conditions, but it is giving wrong result.

Please help me with the same.

Details are in the file attached.

Regards,
MS

 

[vletm]

msharma864512
Have You search something same kind of threads?
eg

Index Match with multiple conditions

Hi, I am trying to pull some KPIs using index match with multiple conditions. I have tried the same at my end but its not working. Details are in the attached spreadsheet. Regards, Manish

chandoo.org

 

[msharma864512]

msharma864512
Have You search something same kind of threads?
eg

Index Match with multiple conditions

Hi, I am trying to pull some KPIs using index match with multiple conditions. I have tried the same at my end but its not working. Details are in the attached spreadsheet. Regards, Manish

chandoo.org

thanks Vletm, it is working fine now