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".