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