W
wammer
Any ideas on how to shorten this behemoth formula. Is there some typ
of Macro I can create?:
"=if(AND(O$3>=(vlookup($B5,'Master Sheet'!$B$7:$T$2004,'Maste
Sheet'!q$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!R$5,FALSE))),concatenate($m5,'Maste
Sheet'!Q$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!S$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!T$5,FALSE))),concatenate($m5,'Maste
Sheet'!s$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!o$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!p$5,FALSE))),concatenate($m5,'Maste
Sheet'!o$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!c$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!d$5,FALSE))),concatenate($m5,'Maste
Sheet'!c$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!e$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!f$5,FALSE))),concatenate($m5,'Maste
Sheet'!e$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!g$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!h$5,FALSE))),concatenate($m5,'Maste
Sheet'!g$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!i$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!j$5,FALSE))),concatenate($m5,'Maste
Sheet'!i$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!k$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!l$5,FALSE))),concatenate($m5,'Maste
Sheet'!k$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!m$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!n$5,FALSE))),concatenate($m5,'Maste
Sheet'!m$4),0))))))))))))))))
of Macro I can create?:
"=if(AND(O$3>=(vlookup($B5,'Master Sheet'!$B$7:$T$2004,'Maste
Sheet'!q$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!R$5,FALSE))),concatenate($m5,'Maste
Sheet'!Q$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!S$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!T$5,FALSE))),concatenate($m5,'Maste
Sheet'!s$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!o$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!p$5,FALSE))),concatenate($m5,'Maste
Sheet'!o$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!c$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!d$5,FALSE))),concatenate($m5,'Maste
Sheet'!c$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!e$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!f$5,FALSE))),concatenate($m5,'Maste
Sheet'!e$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!g$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!h$5,FALSE))),concatenate($m5,'Maste
Sheet'!g$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!i$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!j$5,FALSE))),concatenate($m5,'Maste
Sheet'!i$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!k$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!l$5,FALSE))),concatenate($m5,'Maste
Sheet'!k$4), (if(AND(O$3>=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Maste
Sheet'!m$5,FALSE)),o$3<=(vlookup($B5,'Maste
Sheet'!$B$7:$T$2004,'Master Sheet'!n$5,FALSE))),concatenate($m5,'Maste
Sheet'!m$4),0))))))))))))))))