Does anyone know why a vlookup formula would not calculate until I retype the
lookup value in it's cell? The formatting in the lookup value cell is
exactily the same as in the table array, but until I manually retype the
lookup value cell, the formula just gives me the old #NA.

Help.
Don