Oct 10 2019 06:37 PM
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
Oct 10 2019 07:29 PM
SolutionC3 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.
Oct 11 2019 05:57 AM
@Kodipady Works perfectly! Thank you so much!
Oct 10 2019 07:29 PM
SolutionC3 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.