How do I automatically enter the data on condition of another cell:
If type 1 then old NO
If type 2 then New NO
If type 3 then New NO
If type 4 Then Old NO

where New No Column a
and Old NO column B
Type is Column C
date req in column d

mUCH APPRICATIED IF ANYONE CAN HELP WITH FORMULAR