I think you are looking for the VLOOKUP function. If you type in the formula shown below into cell I3 on worksheet L1-6, the formula will return 3.864, the Euro Chop Price for that item.
=VLOOKUP(G3,'Arquadia supplier'!$A$2:$G$2443,7,FALSE)