The Vlookup formula returns #n/a instead of a number in several rows in my
worksheet. If I retype the lookup number or add a ' in front of the lookup
number, the formula will work. However, I have hundreds of rows of data and
would have many #N/A's to correct using this method. Does anybody know how
to correct the formula, etc. to prevent this?
--
Thanks,
Mike