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