[SOLVED] Formula that will give me output "Complete" and "Ongoing" based on lookup value

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:

=IFERROR(IFS(VLOOKUP(C9,RawData!A:A,1,FALSE),"Ongoing"),"Complete")

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.


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!