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 = ""
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 = ""
=IF(J10>1000,Sheet2!D1,"")
If sheet 2 name contains a space then
=IF(J10>1000,'My Sheet'!D1,"")
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'