INDEX MATCH FORMULA N/A# ERROR

[DeltaShell]

I would like to have this formula return a "text" word of my choosing instead of N/A# if there is no match - but I can't figure out how to nest the formula within an IFERROR - Can anyone help? Thank you in advance!

INDEX($H$2:$H$1496,MATCH(H18,$H$2:$H$1496,0),0)

 

[SanjayGMusafir]

Unable to understand what you are trying to do with this Index Match. Give some data or perspective to understand what you want to do.

 

[Alex Blakenburg]

The syntax for Iferror is
=IFERROR( value, value_if_error)
your current entire formula replaces the blue value
=IFERROR( INDEX($H$2:$H$1496,MATCH(H18,$H$2:$H$1496,0),0), "Not Found")

 

[DeltaShell]

Thank you so Much!!! I thought I had tried that but apparently not!

 

[Alex Blakenburg]

You only need a comma or a bracket in the wrong place and it doesn't work.
In case it helps, if you start typing "Iferror(" in front of your existing formula and the click on the word "value" it will show where you are up to.
In the below image it shows you need to add from the comma "," on.

It will also allow you to put in extra spaces to show clearer separation between the components as I have in my post (extra space after the first open bracket and another after the comma of the IFERROR.)