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

Hi,

I am creating a sales mix for my workplace using excel. Something that i can just dumb the data into and get excel to do the work.

Its gotten to the part where it now need to ensure that the exact name of the menu item needs to be categorised.

Example:

I have categories specific items as deserts.

Baklava is the menu item we sell however i have Baklava AMEN which is what we use to give it as an amenity. I need it where it only picks up the first and not the later. Using the below formula i am able to get it working but i need to fit in Exact
formula into it.

=IFERROR(INDEX($N$5:$N$271,MATCH(TRUE,ISNUMBER(SEARCH($O$5:$O$271,A34)),0)),"")

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

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.