Replacing #N/A with other text

[Guest]

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

 

[Anne Troy]

=if(isna(vlookup...),"No Data",vlookup....)
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Thanks, Anne; worked great. ( I knew it was something easy).

Dave