Avoiding index match N A value

Question

When a value and combined name in column L match, I index column O.

A #N/A value will be returned if the combined name cannot be found in the table I am indexing or matching. How can I prevent this? I looked at the ISNA function, but all it returns is True or False. I could use this to create a different formula to configure it, but I'm looking for a simpler, faster method.

The current index/match being used is:

=INDEX(O:O,MATCH(ADIST& " " &APROD,L:L,0))

And if I am being passed back a #N/A value I'd like it to say "No Value".

Answer 1

Use IFERROR to set an alternative value if the formula you are using returns an error:

=IFERROR(INDEX(O:O,MATCH(ADIST& " " &APROD,L:L,0)),"No Value")