@JASON.B75, thanks this did the trick I have that same formula for other columns as well. I will work on migrating those numbers into a list range to reduce down the massive conditions on this formula. I took over this from someone else, so just trying to simplify the formulas.

then just add it as another condition to your last AND() function, W1622<>"002534"