Incorporating IFERROR or IF function into complicated nested formula

[J-Griff]

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 

[#2 · Accepted solution]

C3 Formula

=IFERROR(1*LEFT($G3,
FIND("X",$G3)-1),"")

D3 formula

=IFERROR(MID($G3, FIND("X",$G3)+1, FIND("-",$G3)-FIND("X",$G3)-1),"")

E3 Formula

=IFERROR(MID($F3,
FIND("-",$F3)+1,
FIND(" ",$F3)-FIND("-",$F3)-1),"") 

hope this helps. 

[#3]

@Kodipady Works perfectly! Thank you so much!