Lookup1.xlsx

Hi

I have a data download from a system that is not very well designed and I cannot change (see attached).

What I want to do is lookup to see if the value in column A of the output sheet is present in the column A or B of the input sheet if it is I would like it to return the value in column C to Colum B of the output sheet if not return "not present" in column B of the output sheet.

JB