Hello everyone.
I'm trying to create a formula that will give me two different outputs - "Complete" or "Ongoing" - based on the presence of a specific value in the lookup cell.
So far this is what I was able to make up:
What happens now is that is running the formula and outputs "Complete" when the value is present, but if I switch the order of "Ongoing" and "Complete" in the formula, it always shows "Ongoing" even when the lookup value is absent.=IFERROR(IFS(VLOOKUP(C9,RawData!A:A,1,FALSE),"Ongoing"),"Complete")
I need it to look for the value of the cell C9 (on worksheet1) on column A (on worksheet 2). If the value it's present, I need it to display "Ongoing". If the value is absent, I need it to display "Complete".
What am I getting wrong?
Thank you guys in advance for the help!
Bookmarks