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