You new data might be text that looks like numbers, and it might
contain space characters or non-breaking space characters that you
obviously cannot see - use Find & Replace on the column to get rid of
these.

You could amend your formula along these lines:

=VLOOKUP(""&A1, ....

or:

=VLOOKUP(A1*1, ....

in the first case to try to match with text values in your lookup
table where the lookup value is a proper number, and in the second
case to match with real numbers in your lookup table where the lookup
value is a text value.

Hope this helps.

Pete

On Jul 14, 11:36*am, karen wrote:
Does anyone know why this should happen?
I am replicating a vlookup that worked previously, with a new set of data,
but it is returning #n/a for everything, even though I know there is data
there.

I am trying to match number records.
I have changed all columns to text format.
I have multiplied all cells by 1 to ensure accurate
I can't think of what else would mean that they don't match.
Please help.
cheers