isna/iserror functions
 

What versions of Excel allow using these two functions?
--
OneFineDay

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

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?

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

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

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

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

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