I'm sure this is very easy to do, but it's not intuitively obvious and I
can't seem to tailor my question in Excel to get a relevant answer.
I'm using VLOOKUP and I am successful in getting matched values. But I'd
like to change the "#N/A" with a value such as "No Data".
How do I do this?
Thanks,
Dave
Bookmarks