Forum Discussion
Need Help Changing Nested IF formulas to Vlookups
Hi there, I am in the process of trying to clean up Nested IF(AND formulas and converting them to Vlookup tables. I am having a very difficult time trying to figure out how to create some of the...
Kristin,
not fully tested.
=SWITCH(SIGN(CB4-LOOKUP(Shift,{8,10;9,10;10.5,8;12,8})),-1,CB4*Shift,LOOKUP(Shift,{8,10;9,10;10.5,8;12,8})*Shift)*(CD4=2,018)
Detlef, with comment what SWITCH() is only for Office 365 subscribers