=if(vlookup(...)="","",vlookup(...)) Use your real =vlookup() formula in both spots.
D Dave Peterson Dec 7, 2007 #1 =if(vlookup(...)="","",vlookup(...)) Use your real =vlookup() formula in both spots.
R roxiemayfield Dec 7, 2007 #2 Would someone please help me on this formula: =VLOOKUP('Period 1 Week 1'!D11,InTime,2) If the InTime value is r the sum should equal 0 (but I do not want a 0, just want the cell to be blank.
Would someone please help me on this formula: =VLOOKUP('Period 1 Week 1'!D11,InTime,2) If the InTime value is r the sum should equal 0 (but I do not want a 0, just want the cell to be blank.
T T. Valko Dec 7, 2007 #3 Not sure what you want! The subject line says: Sum should be 0. Sum of what? Maybe this: =IF(VLOOKUP('Period 1 Week 1'!D11,InTime,2)="r","",VLOOKUP('Period 1 Week 1'!D11,InTime,2))
Not sure what you want! The subject line says: Sum should be 0. Sum of what? Maybe this: =IF(VLOOKUP('Period 1 Week 1'!D11,InTime,2)="r","",VLOOKUP('Period 1 Week 1'!D11,InTime,2))