Hiding vlookup message #N/A
 

I've copied a vlookup down a column and do not want to see the message "#N/A"
I'm using MSO2000

Hiding vlookup message #N/A
 

=IF(ISNA(vlookupformula),"",vlookupformula)

HTH

"red289" wrote:

I've copied a vlookup down a column and do not want to see the message "#N/A"
I'm using MSO2000

Hiding vlookup message #N/A
 

Thanks for the reponse. would I highlight the column and do the =if(insa ?
and the lookup formula would be exactly as it is in the first cell?

"Toppers" wrote:

=IF(ISNA(vlookupformula),"",vlookupformula)

HTH

"red289" wrote:

I've copied a vlookup down a column and do not want to see the message "#N/A"
I'm using MSO2000

Hiding vlookup message #N/A
 

Go to the first formula in your column, modify it with the ISNA argument, and
copy down. Hit F9 to recalculate if your workbook is not set to automatic
calculation.

Dave
--
Brevity is the soul of wit.


"red289" wrote:

Thanks for the reponse. would I highlight the column and do the =if(insa ?
and the lookup formula would be exactly as it is in the first cell?

"Toppers" wrote:

=IF(ISNA(vlookupformula),"",vlookupformula)

HTH

"red289" wrote:

I've copied a vlookup down a column and do not want to see the message "#N/A"
I'm using MSO2000

Hiding vlookup message #N/A
 

Doing something wrong. Here's what I have.
=If(isna(VLOOKUP(C3,'User Listing'!A:D,3,FALSE),"",VLOOKUP(C3,'User
Listing'!A:D,3,FALSE)

"Dave F" wrote:

Go to the first formula in your column, modify it with the ISNA argument, and
copy down. Hit F9 to recalculate if your workbook is not set to automatic
calculation.

Dave
--
Brevity is the soul of wit.


"red289" wrote:

Thanks for the reponse. would I highlight the column and do the =if(insa ?
and the lookup formula would be exactly as it is in the first cell?

"Toppers" wrote:

=IF(ISNA(vlookupformula),"",vlookupformula)

HTH

"red289" wrote:

I've copied a vlookup down a column and do not want to see the message "#N/A"
I'm using MSO2000

Hiding vlookup message #N/A
 

You're missing some closing parentheses, around the ISNA() function and the
IF() function:
=If(isna(VLOOKUP(C3,'User Listing'!A:D,3,FALSE)),"",VLOOKUP(C3,'User
Listing'!A:D,3,FALSE))

Dave
--
Brevity is the soul of wit.


"red289" wrote:

Doing something wrong. Here's what I have.
=If(isna(VLOOKUP(C3,'User Listing'!A:D,3,FALSE),"",VLOOKUP(C3,'User
Listing'!A:D,3,FALSE)

"Dave F" wrote:

Go to the first formula in your column, modify it with the ISNA argument, and
copy down. Hit F9 to recalculate if your workbook is not set to automatic
calculation.

Dave
--
Brevity is the soul of wit.


"red289" wrote:

Thanks for the reponse. would I highlight the column and do the =if(insa ?
and the lookup formula would be exactly as it is in the first cell?

"Toppers" wrote:

=IF(ISNA(vlookupformula),"",vlookupformula)

HTH

"red289" wrote:

I've copied a vlookup down a column and do not want to see the message "#N/A"
I'm using MSO2000