formula only work if other cell has data

[Kirstym1918]

Hi all,
Could anyone help me with this formula below, I would likeit to only calculate and return “SPARE/VOR” if D78 is not blank but I have noidea where to nest it in the formula but not for want of trying would it be =NOT(ISBLANK)?

If someone would be so kind as to add it to the formula andexplain it to me, I would be very grateful

=IFERROR(IF(MATCH(D78,Monday!$C$6:$C$122,0),"ROUTE",),"SPAREor VOR?")
Thanks

 

[gaz_chops]

Try

=if(D78="","",IFERROR(IF(MATCH(D78,Monday!$C$6:$C$122,0),"ROUTE",),"SPAREor VOR?"))

The part in RED says IF D78 is blank, then return a blank, otherwise run your formula.

hth

 

[Kirstym1918]

And so simple, I really do over complicate things when it comes to working out formulas

Many thanks Gaz

 

[gaz_chops]

You're welcome.