Hello!
Can anyone help me find the error in the following google sheets formula. The error message is "VLOOKUP evaluates to an out of bounds range". The problem is that I cannot find any issues with the formula.
[FORMULA][/=if($A2=ʺʺ,ʺʺ,if(and(vlookup($A2,'Uniform Violation 8th and 7th grade '!$A:$FR,columns($D$1:D$1)+3,false)=ʺʺ,vlookup($A2,'Cursing 8th and 7th Grade '!$A:$FR,columns($D$1:D$1)+3,false)=ʺʺ,vlookup($A2,'Late to class 8th and 7th Grade'!$A:$FR,columns($D$1:D$1)+3,false)=ʺʺ,vlookup($A2,'Gum 8th and 7th grade'!$A:$FR,columns($D$1:D$1)+3,false)=ʺʺ,vlookup($A2,'Cutting Class/ Wandering 8th and 7th Grade '!$A:$FR,columns($D$1:D$1)+3,false)=ʺʺ,vlookup($A2,'Dismissal Violation 8th and 7th Grade'!$A:$FR,columns($D$1:D$1)+3,false)=ʺʺ,vlookup($A2,'Unwanted Cell Phone Use in Class'!$A:$FR,columns($D$1:D$1)+3,false)=ʺʺ),ʺʺ,concatenate(ʺUNIFORM: ʺ,vlookup($A2,'Uniform Violation 8th and 7th grade '!$A:$FR,columns($D$1:D$1)+3,false),CHAR(10),ʺCURSING: ʺ,vlookup($A2,'Cursing 8th and 7th Grade '!$A:$FR,columns($D$1:D$1)+3,false),CHAR(10),ʺLATE: ʺ,vlookup($A2,'Late to class 8th and 7th Grade'!$A:$FR,columns($D$1:D$1)+3,false),CHAR(10),ʺGUM: ʺ,vlookup($A2,'Gum 8th and 7th grade'!$A:$FR,columns($D$1:D$1)+3,false),CHAR(10),ʺCUTTING: ʺ,vlookup($A2,'Cutting Class/ Wandering 8th and 7th Grade '!$A:$FR,columns($D$1:D$1)+3,false),CHAR(10),ʺDISMISSAL: ʺ,vlookup($A2,'Dismissal Violation 8th and 7th Grade'!$A:$FR,columns($D$1:D$1)+3,false),CHAR(10),ʺCELL PHONE: ʺ,vlookup($A2,'Unwanted Cell Phone Use in Class'!$A:$FR,columns($D$1:D$1)+3,false))))FORMULA]
Thanks!
Bookmarks