Index Match with multiple conditions

[msharma864512]

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

 

[Nebu]

Hi:

May be this?

Thanks

 

[msharma864512]

P

Hi:

May be this?

Thanks

Thank you Nebu, this is exactly I was looking for.