I have this formula in one of my sheets which is working ok but if the statement is False it adds up an empty row which I don’t like it

=IF(LEFT(Entry!B15,3)="Design",Entry!B15,"")

Is there anyway to modify this formula so when the "Entry" sheet doesn't contain "Design" the formula does nothing?

Would it be better to use a Vlookup formula and if yes how is the syntax?

I prefer not to use a Macro or VB code