replace
...Offset(, 1)
with
...Offset(, 4)
to get output in column E
For your multiple condition:
your need to build a formula that match your needs.
Actual formula is in the form:
IF(Condition1, Answer1, empty)
for 3 conditions you need something like:
IF(Condition1, Answer1, IF(Condition2, Answer2, IF(Condition3, Answer3, empty)))