INDEX & MATCH Function, IF

[excellicious]

I have two formulas that are not given me a correct return. Could you take a look and tell me what I did wrong?

The first formula locates in column E
=INDEX($M$3:$M$20,MATCH(E7,$N$3:$N$20,0))
The second formula locates in column G
=IF(F7>E7,"missed","")

TIA
Excellicious

[Paul]

Hi Excellicious,

I think the formula you're looking for in E7:E16 is:

=INDEX($N$3:$N$20,MATCH(D7,$M$3:$M$20,0))

This matches D7 (not E7, which creates a circular reference) in column M and returns the associated value from column N.

Your second formula works once the first is setup correctly.

[excellicious]

It works great. Thank you for you assistance!