A 3 minute lesson in how to do INDEX MATCH the easy way.
Here's the iii shortcut formula for you to copy =INDEX( Step3_Result_Column, MATCH( Step1_Lookup_Cell, Step2_Lookup_Column, 0),0)
Also please vote here for a simpler version of INDEX MATCH
[ Ссылка ]
Ещё видео!