I am trying to evaluate a cell, and depending on what the value is, enter either a 0 or go thru with the VLOOKUP.
Here is the formula I am using in cell E4
=IF($E$3,"Wg Missing",0)=VLOOKUP($B$2,FEB!$A$14:$CH$43,7)
Add'l info: Cell E3 is doing an evaluation of it's own --
=IF($B$2<>E$264,"Wg Missing","February")
I keep getting error #VALUE so I know I'm not doing this right. I'd appreciate any ideas you all have. Thank you for your help.
Here is the formula I am using in cell E4
=IF($E$3,"Wg Missing",0)=VLOOKUP($B$2,FEB!$A$14:$CH$43,7)
Add'l info: Cell E3 is doing an evaluation of it's own --
=IF($B$2<>E$264,"Wg Missing","February")
I keep getting error #VALUE so I know I'm not doing this right. I'd appreciate any ideas you all have. Thank you for your help.