Last answered:

21 Sept 2022

Posted on:

20 Sept 2022

0

Resolved: Excel formula question

this is the question
download.png



the data
the data







my question is why we didn't choose all the above
I got the result with the INDEX & MATCH formula
and can I know the INDEX & MATCH & MATCH formula cuz I couldn't solve it with the 3 functions
image









what is wrong here? index+match+match
image

2 answers ( 1 marked as helpful)
Instructor
Posted on:

21 Sept 2022

0

Hey Peter,
Good to hear from you. Thanks for the interesting question.
The idea is that you'll need to create multiple INDEX&MATCH functions. Whereas with only one INDEX,MATCH, MATCH you can fill in the entire sheet because it has lookup values both horizontally and vertically.
Best,
Ned

Posted on:

21 Sept 2022

0

aha
Thank you a lot
but can you show me the formula of 

INDEX, MATCH, MATCH

, please

Submit an answer