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

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