PDA

View Full Version : Solved: conditional population of cell



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 = ""

mdmackillop
08-15-2008, 01:37 PM
=IF(J10>1000,Sheet2!D1,"")

If sheet 2 name contains a space then
=IF(J10>1000,'My Sheet'!D1,"")