How to fit in Exact Match into an Index and Match formula that contains Isnumber

Originally Posted by RaulSerg

Hmm, I think your INDEX/MATCH formula is simply upside down.
You may have mixed up the search and within arguments/ranges.

I think what you're looking at is: =IFERROR(INDEX($N$5:$N$271,MATCH(TRUE,EXACT(A6,$O$5:$O$271),)),"")

btw - your column I is formatted as text which also causes some issues.
You may also wish to revisit your column S formulas: they're not exact matches and therefore likely producing incorrect results, such as #17.

Regards

WOW many thanks for your help. Its done the trick.

i just need to fix my ranking so that it doesnt give me duplicates but instead gets me the next rank. just need to find the correct formula for that.