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