| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
isna/iserror functions
What versions of Excel allow using these two functions?
-- OneFineDay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isna/iserror functions
All
-- Kind regards, Niek Otten Microsoft MVP - Excel "M Thompson" wrote in message ... What versions of Excel allow using these two functions? -- OneFineDay |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isna/iserror functions
All of them as far as I recall.
Note: 2007 has added a new IFERROR function Gord Dibben MS Excel MVP On Sat, 23 May 2009 13:30:00 -0700, M Thompson wrote: What versions of Excel allow using these two functions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isna/iserror functions
I think every version has those functions. I'm sure every "recent" version
has them, Excel 97 to Excel 2007. -- Biff Microsoft Excel MVP "M Thompson" wrote in message ... What versions of Excel allow using these two functions? -- OneFineDay |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isna/iserror functions
Thanks. That's what I thought, but I'm having trouble getting either one to
work with vlookup, so I thought they must only be available in certain versions. I have this: =VLOOKUP(A42,County_by_City, 3,0) I tried this: =IF(ISNA(VLOOKUP(A42,County_by_City,3),0,vlookup(A 42,County_by_City,3,0)) Excel keeps telling me there's a problem with the first zero, and always wants another left parenthesis at the end? Any ideas? Thanks to all for your time, and have a great holiday. -- OneFineDay "M Thompson" wrote: What versions of Excel allow using these two functions? -- OneFineDay |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isna/iserror functions
wants another left parenthesis at the end?
Yes, you're missing a closing parenthesis for the ISNA function. Also, what type of lookup are you wanting to do? Do you want to find *exact* matches only? Or, do you want to find "approximate" matches? For exact matches only: =IF(ISNA(VLOOKUP(A42,County_by_City,3,0)),0,VLOOKU P(A42,County_by_City,3,0)) For "approximate" matches: =IF(ISNA(VLOOKUP(A42,County_by_City,3)),0,VLOOKUP( A42,County_by_City,3)) -- Biff Microsoft Excel MVP "M Thompson" wrote in message ... Thanks. That's what I thought, but I'm having trouble getting either one to work with vlookup, so I thought they must only be available in certain versions. I have this: =VLOOKUP(A42,County_by_City, 3,0) I tried this: =IF(ISNA(VLOOKUP(A42,County_by_City,3),0,vlookup(A 42,County_by_City,3,0)) Excel keeps telling me there's a problem with the first zero, and always wants another left parenthesis at the end? Any ideas? Thanks to all for your time, and have a great holiday. -- OneFineDay "M Thompson" wrote: What versions of Excel allow using these two functions? -- OneFineDay |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isna/iserror functions
Thanks! That did it.
Have a great weekend -- OneFineDay "T. Valko" wrote: wants another left parenthesis at the end? Yes, you're missing a closing parenthesis for the ISNA function. Also, what type of lookup are you wanting to do? Do you want to find *exact* matches only? Or, do you want to find "approximate" matches? For exact matches only: =IF(ISNA(VLOOKUP(A42,County_by_City,3,0)),0,VLOOKU P(A42,County_by_City,3,0)) For "approximate" matches: =IF(ISNA(VLOOKUP(A42,County_by_City,3)),0,VLOOKUP( A42,County_by_City,3)) -- Biff Microsoft Excel MVP "M Thompson" wrote in message ... Thanks. That's what I thought, but I'm having trouble getting either one to work with vlookup, so I thought they must only be available in certain versions. I have this: =VLOOKUP(A42,County_by_City, 3,0) I tried this: =IF(ISNA(VLOOKUP(A42,County_by_City,3),0,vlookup(A 42,County_by_City,3,0)) Excel keeps telling me there's a problem with the first zero, and always wants another left parenthesis at the end? Any ideas? Thanks to all for your time, and have a great holiday. -- OneFineDay "M Thompson" wrote: What versions of Excel allow using these two functions? -- OneFineDay |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isna/iserror functions
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "M Thompson" wrote in message ... Thanks! That did it. Have a great weekend -- OneFineDay "T. Valko" wrote: wants another left parenthesis at the end? Yes, you're missing a closing parenthesis for the ISNA function. Also, what type of lookup are you wanting to do? Do you want to find *exact* matches only? Or, do you want to find "approximate" matches? For exact matches only: =IF(ISNA(VLOOKUP(A42,County_by_City,3,0)),0,VLOOKU P(A42,County_by_City,3,0)) For "approximate" matches: =IF(ISNA(VLOOKUP(A42,County_by_City,3)),0,VLOOKUP( A42,County_by_City,3)) -- Biff Microsoft Excel MVP "M Thompson" wrote in message ... Thanks. That's what I thought, but I'm having trouble getting either one to work with vlookup, so I thought they must only be available in certain versions. I have this: =VLOOKUP(A42,County_by_City, 3,0) I tried this: =IF(ISNA(VLOOKUP(A42,County_by_City,3),0,vlookup(A 42,County_by_City,3,0)) Excel keeps telling me there's a problem with the first zero, and always wants another left parenthesis at the end? Any ideas? Thanks to all for your time, and have a great holiday. -- OneFineDay "M Thompson" wrote: What versions of Excel allow using these two functions? -- OneFineDay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between ISNA and ISERROR | Excel Discussion (Misc queries) | |||
| IF(ISNA.. or ISERROR? question.. | Excel Discussion (Misc queries) | |||
| conditional formating iserror isna | Excel Discussion (Misc queries) | |||
| Use both ISNA and ISERROR in a long formula | Excel Worksheet Functions | |||
| isna & if functions | Excel Worksheet Functions | |||
Linear Mode
