Index/Match

[Noz2k]

What I'm trying to do is use a value in column J of my sheet to find the matching value in column A of sheet2, and return the value in the corresponding row of column N.

Here is what I am trying

=INDEX(Sheet2!$N$3:$N$20000,MATCH($J2,Sheet2!$A$3:$A$20000,0))

*entered as an array.

Where am I going wrong?

 

[Noz2k]

Thanks, I had to go to Data-Text to Columns for the data in Sheet2 column A and now it works.

Thanks for the help