INDEX MATCH NOT WORKING between two tabs

[rayted]

Hi guys,

I`m trying to get my data from sheet1 (cell J2), to appear on J2 on sheet2. I am using index match:

=INDEX(Sheet2!B2:B14,MATCH(Sheet1!B2:B14,10))

but getting N/A error

Any idea why?

thank you

[AliGW]

Marked as solved - is it?

Syntax wrong - no lookup value. Try this:

=INDEX(Sheet1!$J$2:$J$14,MATCH(A2,Sheet1!$A$2:$A$14,0))