nitzbar
08-15-2008, 01:01 PM
how do i populate a cell from data from a diff sheet depending on whether the adjacent cell fulfils a condition ?
eg if j10>1000 then k10 = ___ <value from sheet2> else k10 = ""
eg if j10>1000 then k10 = ___ <value from sheet2> else k10 = ""