isna/iserror functions

G

Gord Dibben

All of them as far as I recall.

Note: 2007 has added a new IFERROR function


Gord Dibben MS Excel MVP
 
T

T. Valko

I think every version has those functions. I'm sure every "recent" version
has them, Excel 97 to Excel 2007.
 
M

M Thompson

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(A42,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.
 
T

T. Valko

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,VLOOKUP(A42,County_by_City,3,0))

For "approximate" matches:

=IF(ISNA(VLOOKUP(A42,County_by_City,3)),0,VLOOKUP(A42,County_by_City,3))
 
Top