Finally I figure out how to use this formula ({=INDEX(Sheet1!A1:A1000,MATCH(1,(Sheet1!B1:B1000= $ A2)*(Sheet1!C1:C1000=$B2)*(Sheet1!D11000=$C2),0))}
But if I am not matching but Vlook the WIP no., how should I do please?
Finally I figure out how to use this formula ({=INDEX(Sheet1!A1:A1000,MATCH(1,(Sheet1!B1:B1000= $ A2)*(Sheet1!C1:C1000=$B2)*(Sheet1!D11000=$C2),0))}
But if I am not matching but Vlook the WIP no., how should I do please?
Bookmarks