• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index Match not working

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

Attachments

  • Simple Index Match.xlsx
    192.7 KB · Views: 10
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,
 
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
 

Attachments

  • Simple Index Match.xlsx
    192.9 KB · Views: 7
Back
Top