| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding error message | Excel Worksheet Functions | |||
| Removing Rows for Printing | Excel Worksheet Functions | |||
| Message Input with link to different work sheet | New Users to Excel | |||
| Message Input with link to different work sheet | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
