look up the value on the basis of given dates

[akshay6s]

hi everyone. i have a production file. it has two sheets. first is "production". and second is "track difference". in sheet "production" we records daily machine
production and in sheet "track difference" we checks difference between ideal production and actual. ideal production is in i column and actual production is in sheet "production". column c is weavers name column in sheet "production". i need weaver wise production difference detail in sheet "track difference.

for example:- a3 is loom no. 3 on date 31/1/2019. and opeartor is bittu. a4 on same date is machine no. 4 and operator is ankit-3. so i want these names in bj3 and bj4 and so on in sheet " track difference". so that i can find out which weaver is doing well or which need to be improved.

hoping to be get solved. thanks in advance.