Incorporating IFERROR or IF function into complicated nested formula

As you will see in the attached spreadsheet, the below nested formula works well in columns C,D, & E under normal conditions; However, when column G differs in content the result is #VALUE!

=MID($F39,
FIND("-",$F39)+1,
FIND(" ",$F39)-FIND("-",$F39)-1)

Is it possible to incorporate an IF or IFERROR function to follow or precede aforementioned formula above? Ideally, it would look something like this,

IF(G3="VERANDA PRIVACY LATTICE 4X8 VINYL WHITE","")

Any help is greatly appreciated!

Cheers,

John