please help me

I HAVE TWO EXCEL FILES

FIRST IS 4 MD MARCH AND OTHER FILE IS NEW MICROSOFT EXCEL SPREADSHEET

IN NEW MICROSOFT EXCEWL FILE U CAN SEE IN A ROW AS ITEM CODE FROM 1 TO 140 IN SOME IT WILL GOES NUMERICALLY IN SOME IT GOES RANDOMLY SO I HAVE USED IF FORMULA IN 4 MD MARCH TO GET ITS SALE VALUE FROM NEW MICROSOFT SHEET BUT PROBLEM IS IF ITEM CODE CHANGES THAN IN MY 4 MD MARCH FILE IT SHOWS FALSE SO HOW TO CALCULATE IT IN WHICH FORMAULA SO IF I PASTE ANY ITEM CODE IT SHOULD GO TO ITS EXACT PLACE

AttachmentSize
4 MD MARCH.xlsx161.43 KB
New Microsoft Office Excel Worksheet.xlsx16.27 KB