Hello and welcome to my problem.

I have a column of 'quantity' (C) and a column of 'part #'s' (D).

The formula only works if I put a zero in column D, wouod like it to work
for a 'blank'

=IF(COUNTA(C24:C77)<(COUNTA(D24:D77)),"","Line "&(MATCH(0,D24:D77)-22)&" is
missing part a number.")
--
parts galore
--
Happy ßuππy (O \ | / O) VW''s rule
because it''s a car with camel toe ;)
() ()
(°ˆ™Â°) - go suck an Easter Egg
(" " )—‹