Hello,

I am trying to make a report by using two different MS excel. Both the sheet have same and unique code number like - 75262, 4455. I am trying make a report like - if the Code (Sheet 1) matched with the code of Sheet 2, then it will show "Completed", if not matched, then it will show " not done".

I tryed through following formula - =IFERROR(VLOOKUP(E4,[QA.xlsx]Sheet1!$E$2:$E$33,1,FALSE),"Not Done"). Which shows the Code number id matched, and Not Done if the not matched. But I need to replace the Code with "Completed". Please suggest me, what to do?

Thank U.
Best
Rinko