Formula 1

IF L2 is blank and J2 doesn’t contain (AT1R/LCTI/LPRI/LPRI_RPT/LPRII/LPRII_RPT), if true return “NoOrderNumberFound”, otherwise “Not Reported”.

Formula 2

IF L2 is not blank, lookup N2 in row P(has sorted unique values) and return either “WrongTest” if not found, or “CorrectTest” if it was found.

=IF(ISERROR(VLOOKUP(N2,P:P,1,FALSE)),"WrongTest","CorrectTest")

Thank you,

Lenna