I have the following list (which in real terms goes to 10 variables). I have
tried nested IF's but got nowhere. What is the best way of auto-completing
the Result column

TargetA ActualA TargetB ActualB Result
m/d/y m/d/y CompleteA
m/d/y AwaitingA
m/d/y AwaitingB
m/d/y m/d/y CompleteB