Hi,

I'm trying to match a value(Column1) to another value from a range (Column2) and display a value from (Column3).

It does not display a value, but #NA.

However, when i manually type the data on Column1, it will display a value from Column 3, if it matches column 2.

Tried all sorts of cell formatting, but it still does not work. Basically, the copied and pasted data does not read.

Appreciate your help on this.

formula looks like this:

=INDEX($K$2:$K$742,MATCH(A2,$J$2:$J$742,0))