In the attached file i want compare K2 in production sheet with A4 TO A31 in data entry sheet, and return the vaue which is in next row in matched colunm.

for example in attached example. returned value shoud be 25.5.

i want to apply thid formula in D10 HIGHLIGHTED WITH RED PAINT.

KINDLY HELP.

Similar questions and discussions