I am having difficulties with creation of a formula to perform what I have described below:
The formula for the logic below will exist in cell C2 of the IMAC-D Summary worksheet:
If the value in cell J2 of the IMAC-D Summary worksheet DOES NOT EXIST in column A of the Lookup – Aged worksheet, then return “SN NOT FOUND”
If the value in cell J2 of the IMAC-D Summary worksheet DOES EXIST in column A of the Lookup – Aged worksheet, AND, if the value in F2 of the IMAC-D Summary is “Disposal”, then,
If the value in column B of the Lookup – Aged worksheet is greater than 7.99, then return “In Scope”
If the value of column B of the Lookup – Aged worksheet is less than 8.00, then return “OOS
The formula for the logic below will exist in cell C2 of the IMAC-D Summary worksheet:
If the value in cell J2 of the IMAC-D Summary worksheet DOES NOT EXIST in column A of the Lookup – Aged worksheet, then return “SN NOT FOUND”
If the value in cell J2 of the IMAC-D Summary worksheet DOES EXIST in column A of the Lookup – Aged worksheet, AND, if the value in F2 of the IMAC-D Summary is “Disposal”, then,
If the value in column B of the Lookup – Aged worksheet is greater than 7.99, then return “In Scope”
If the value of column B of the Lookup – Aged worksheet is less than 8.00, then return “OOS