Index Match not working

[Ecel Dumbo]

Hi, Could you please refer attached worksheet and help where i went wrong with the index match formula ? Thanks

 

[Khalid NGO]

Hi,

I think it should be:
=INDEX($D$8:$D$20,MATCH($C2&$D2,$B$8:$B$20&$C$8:$C$20,0),)

With Ctrl+Shift+Enter

Regards,

 

[Ecel Dumbo]

Thanks again Khalid. Worked well

 

[marninei]

Hi,

INDEX syntex is INDEX(array, row_num, [column_num]) while your array consists of a single column. Your data is not arranged in the right form to utilize this formula with multiple conditions.

Attached is my suggestion for a solution.

Oren

 

[marninei]

Hi,

I think it should be:
=INDEX($D$8:$D$20,MATCH($C2&$D2,$B$8:$B$20&$C$8:$C$20,0),)

With Ctrl+Shift+Enter

Regards,

Very nice, I had no idea you could do this.

 

[Khalid NGO]

Very nice, I had no idea you could do this.

Thanks Oren.

Thanks again Khalid. Worked well

Glad it worked well for you.
Keep visiting.