Hide False result in cell when using nested if and vlookup formula

[kels89237]

Hey, I have a formula, below, that returns "False" until the user has filled out certain fields. How can I have it hide "false"? The IFERROR is not working.

=ERROR(IF(C3="Reschedule","Schedule",IFC$="Yes","Schedule",IF(C4-"No",VLOOKUP(C7,'Diagnosis Solutions'!A1:G10,6,FALSE))))"")

 

[Aladin Akyurek]

What are these bits?

C$="Yes"
C4-"No"

Care to word what you want to do?

 

[kels89237]

So sorry, C$ needs to be C4. I want my field to return "Schedule" if C3 = "Reschedule". I wasn't my field to return "Schedule" if C4 = Yes, and I want my field to return the result of my vlookup if C4 = "No". This works perfectly! However, before C3 and C4 have items in them, my field is showing "False". Obviously, the formula can't find what it needs due to the fields being empty. However, I want to hide the "False" result. I added IFERROR and it corrected the #NA result, but not the false result.