At the packing bench, put Packed in B and Required in C. A kit with six packed and eight required is Short. With eight packed, it is Ready. This policy allows extras.
Check for missing counts before comparing
Enter this formula in D2 and copy it to the kit rows.
=IF(OR(B2="",C2=""),"Check input",IF(B2<C2,"Short","Ready"))The outer IF asks for review if either count is empty. With both present, the inner IF compares the quantities.

Illustrated comparison with both inputs present.
Test blank, zero and an exact match
With C2 at 8, clear B2 and expect Check input. Type a real 0 and expect Short. Type 8 and expect Ready. If a data export can supply text or negative counts, validate those inputs separately before trusting the status.

Illustrated boundary test for a kit requiring eight parts.



