Hello - below is a screenshot of my worksheet, I have some success with our formula so far, but need it to check for the department as well as the number check.
For reference, the formula so far is
=IF(COUNTIFS({FY24_SO#}, @cell = [ORDER#]@row) + COUNTIFS({FY24_WO#}, @cell = [ORDER#]@row) = 0, "none", "DEFECT!")
this checks two columns on a referenced sheet and returns basic true/false if a number matches; conditional formatting highlights where true. I found this formula example on another community post and applied it here to some success.
I need to add the department column to the formula - i.e. I need the true/false statement to match a 3rd (department) column on the reference sheet, and then return the true/false value.
the department will change over time (to either FAB or WELD) if I can get this to work - so logically I am asking
=IF(check ref sheet for SO number/WO number) AND (check if department is the same) THEN (return yes/no)
it's likely something simple that i just can't see.
any help is appreciated, TIA
PS - I have already tried a few things, but none seem to work (I get INVALID and UNPARSEABLE typically), and DCHLPR is for an automation I'm working on.
