combining two pairs of columns

I have four columns of results, columns A and B belong together (they are price and associated quantity) and columns C and D belong together (which are also a price and an associated quantity).
Usually there will only be a result in columns A and B, or, columns C and D, but sometimes the results do appear in both A and B, and also C and D.
If results appear in both A and B, and also C and D, then i want to take the results from A and B only.

What im trying to do is combine the two sets of data (with a result in A and B taking preference to a result in C and D) so that i just have one set of results in columns E and F.
Ive attached a workbook to what the result will look like in cols E and F

In G2, drag it across and down

=IF(COUNTA($A2:$B2)=0,C2,A2)

Look at the attached. I put the formulas in G and H, but you just need to copy them into E and F

Rick i got an error with yours.
Jie, thanks that works.
Alan, yours is tricky and im as clear as i need to be on it.

Please Login or Register  to view this content.

Can you explain it because i need to write it in VBA without the R1C1 refs that i get from the macro recorder:

Please Login or Register  to view this content.

If C2 is blank or if C2 and A2 are not blank, then use the value in A2. If the preceeding sentence is false, then use the value in C2.

Alan