Each week we need to audit 5,000 + rows of data, to determine if the data is Okay or if there is an Error.
Essentially what we need is an IF(AND( formula for 37 combinations, which leads me to believe we need a VBA Vlookup Array formula. But, at this point I'm lost. See attached file.
Any assistance or insight would be greatfully appreciated.