Resolved: Excel formula question
this is the question
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
what is wrong here? index+match+match
2 answers ( 1 marked as helpful)
Ned Krastev
Instructor
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
aha
Thank you a lot
but can you show me the formula of
INDEX, MATCH, MATCH
, please