index match not working

[chingg1011]

hi expert,

pls see the attached

why n3 cannot return to '1 Sep 24' ? when I used index match formula

n3: =index(F:F, Match("Next day", J:J, F:F))

Dennis

 

[arthurbr]

The last part of the MATCH should be 0 instead of F:F

 =INDEX(F:F;MATCH("Next day";J:J;0))

FYI referencing entire columns is bad practice