Return text value base on match index

[Bravo33]

I am trying to match a range of references between two worksheets to return corresponding text string .

so far I've got this but to no avail.

{=INDEX('Sheet 2'!F$3;F$2000,MATCH(A1,'Sheet 2'!A$3;A$2000))}

Sheet 2 A$3: A$2000 contains references
Sheet 1 A1 is a reference
Sheet 2 F$3:F$2000 contains numbers and text

Any help appreciated.

 

[tyija1995]

Hey,

That looks correct... what error do you get?

Also is that a semi-colon you're trying to use for specifying a range? F$3;F$2000 should be F$3:F$2000