| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"#N/A" -- can I convert to a "0" (zero)?
I have just learned to pull query data into a spreadsheet through VLOOKUP.
However some years have no data in the query and it returns an #N/A in the cell. I cannot figure out how to convert those to a '0'. Any master of Excel out there have any suggestions? Thanks in Advance! Branchie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"#N/A" -- can I convert to a "0" (zero)?
You need to trap the error: =IF(ISNA(VLOOKUP([your vlookup
formula])),0,VLOOKUP([your vlookup formula])) Dave -- Brevity is the soul of wit. "Branchie" wrote: I have just learned to pull query data into a spreadsheet through VLOOKUP. However some years have no data in the query and it returns an #N/A in the cell. I cannot figure out how to convert those to a '0'. Any master of Excel out there have any suggestions? Thanks in Advance! Branchie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"#N/A" -- can I convert to a "0" (zero)?
=IF(ISNA(VLOOKUP(G2,C1:E24,2,FALSE)),0,VLOOKUP(G2, C1:E24,2,FALSE))
Gord Dibben MS Excel MVP On Thu, 7 Dec 2006 12:56:01 -0800, Branchie wrote: I have just learned to pull query data into a spreadsheet through VLOOKUP. However some years have no data in the query and it returns an #N/A in the cell. I cannot figure out how to convert those to a '0'. Any master of Excel out there have any suggestions? Thanks in Advance! Branchie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert "yes" and "no" to "1" and "0", respectively | Excel Worksheet Functions | |||
| want to return "n/a" or "0" | New Users to Excel | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
