Data from Sheet2 will populate if certain cell in Sheet1 have numerical value.

Hello,

is there an equation that will populate the "task" for the employee if column C has a numerical value.

for example if employee1 has 8 in cell C2 then D2 = "Task1", E2 = "Task2" and G4 = "Task4" (task are from "task" tab).

Any help would be greatly appreciated.

Please see attach excel book.

Thanks.