I am trying to enter the following formula,
=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$49,"")))))
however when I get to
=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$
From this point I cannot enter anymore info as the computer wont let me, I have tried copying and pasting it to no avail
Any thoughts
=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$49,"")))))
however when I get to
=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$
From this point I cannot enter anymore info as the computer wont let me, I have tried copying and pasting it to no avail
Any thoughts