Match Index Doesn't Work

two things, one is that your data in col A is text and you're trying to match it against numeric data in col D. Second is that you are pointing at the wrong cells.
it should be this ... =INDEX(B$2:B$330,MATCH(D2,A$2:A$330,0))
Plus a quick fix for the text in col A, highlight the column and do a find/replace, find what 0 and replace with 0 and make sure it is not set to match whole cell then hit replace all and it'll change them to numeric.

The part nos in column A appear to be text and you appear to have columns A and B the wrong way round in the formula.

Try this in E2 and copy down.

=INDEX(B$2:B$330,MATCH(TEXT(D2, "@"),A$2:A$330,0))

Hi benjie,
it wasn't working for you because you had one column in text format and other in numbers so match function didn't work and you also used lookup in wrong columns. I modified your function and converted numbers to text.
(you can find how to do it for example in this video: https://www.youtube.com/watch?v=x0ssRwGJpmg )

Please check attached file if it works as you want and let me know

Regards.