Index match fail - possibly format issue?!

Hi all,

My index match is letting me down!

Can anyone help me with my file whereby on my 'Adda' tab, I am using index match in columns: B-H, by matching the cell in column A, to column E on sheet 1, $e$2:$e$600. I have tried to change the values, but it's not returning the right values from column E on sheet1! I don't know if duplicate barcodes (column e ON SHEET1) are affecting it OR if it the barcodes in column A (Adda tab) being in NUmber format and number format on ColumN E in sheet1

But if it was a format issue, it would not return any values... surely?>...

Please can someone help as I am doing the ctrl find manually and it's a pain!!

THank you

Sorry file failing to upload!

file attached i`ve deleted data to shrink the file but hopefully my issue still comes across clearly