Excel 2010 - MATCH/INDEX formula

Dear Experts,

I would like to learn the working of Index and Match combinations on the attached example.

Could you please advise which formula could give to C8 cell, that on the North market from Item2 80 pcs is sold, checking the range A1:E4?

thanks,
IndexMatch.xlsx
LVL 1
csehzIT consultantAsked:
Who is Participating?
 
sungenwangConnect With a Mentor Commented:
This will look up the data.
=INDEX(D1:D4,MATCH(B8,A1:A4,0),1)

Open in new window

0
 
Raheman M. AbdulConnect With a Mentor Senior Infrastructure Support Analyst & Systems DeveloperCommented:
=INDEX($B$2:$E$4,MATCH(B8,$A$2:$A$4,0),MATCH(A8,$B$1:$E$1,0))
0
 
csehzIT consultantAuthor Commented:
Thanks very much the solutions
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.