MATCH — Days and months
Find the position of a day of the week or a month of the year in a list using MATCH — 4 guided steps, no fill-down.
=MATCH( value , range , 0 )
1 / 4
What is the position of Wednesday?
=MATCH(E2,A2:A8,0)
2 / 4
What is the position of Saturday?
3 / 4
What is the position of March?
=MATCH(E2,C2:C13,0)
4 / 4
What is the position of November?
Your score is
Restart