If the formatting is correct, could there be an extra "hidden" e.g. blank,
character at the end of the field you are overtyping?

Try TRIM and/OR CLEAN on a cell which is giving a problem to see if this
solves the problem.

HTH

"Bob" wrote:

I have a Vlookup formula that is returning an #N/A for the value of the
formula. Now the formula is written correctly but it only works when I
manually retype the value on the sheet I am trying to return the formula to.

In other words, if I have a value of 1234 on one sheet and value 1234 on the
other sheet is what im trying to match against to return value ABCD

The initial formula will look like so:

Value Return Value

1234 #N/A

When I manually type over the 1234 it will return Value ABCD instead of the
#N/A.

I checked all of the general formatting and it didn't change it, is there
anything im missing?

Thanks,

Bob