Replacing #N/A with other text
 

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

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

"Dave" wrote in message
...
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

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

Dave

"Anne Troy" wrote:

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

"Dave" wrote in message
...
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