Code:
=IF(Acct=Hide_Only,IF(VLOOKUP(F4&$B$13,$Y$13:$AF$429,IF($Z$11=$B$6,2,IF($B$6=$AA$11,3,IF($B$6=$AB$11,4,5))),FALSE)<d3,d3,vlookup(f4&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false)),vlookup(f4&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false))<d6,d6,vlookup(f7&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false)),vlookup(f7&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false))[ code]
Code:
=IF(Acct=Hide_Only,IF(VLOOKUP(F6&$B$13,$Y$13:$AF$429,IF($Z$11=$B$6,2,IF($B$6=$AA$11,3,IF($B$6=$AB$11,4,IF($B$6=$AC$11,5,IF($B$6=$AD$11,6,IF($B$6=$AE$11,7,IF($B$6=$AF$11,8))))))),FALSE)<d5,d5,vlookup(f6&$b$13,$y$13:$af$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false)),vlookup(f6&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false))[ code]
<d5,d5,vlookup(f6&$b$13,$y$13:$af$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false)),vlookup(f6&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false))[ code]
Did I make any syntax error? Or am I missing anything? I gives me #REF! error.
Thank you</d5,d5,vlookup(f6&$b$13,$y$13:$af$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false)),vlookup(f6&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false))[></d4,d4,vlookup(f5&$b$13,$y$13:$af$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,8)))))),false)),vlookup(f5&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,8)))))),false))[></d5,d5,vlookup(f6&$b$13,$y$13:$af$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false)),vlookup(f6&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,if($b$6=$ac$11,5,if($b$6=$ad$11,6,if($b$6=$ae$11,7,if($b$6=$af$11,8))))))),false))[></d3,d3,vlookup(f4&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false)),vlookup(f4&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false))<d6,d6,vlookup(f7&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false)),vlookup(f7&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false))[>
Last edited: