In a table, two of the columns contain the following:

Col A Col. B Col. C
Row 1 Employee Name 1% 7%
Row 2 Williams 5 Blank
Row 3 Peter Blank 42
Row 4 David Blank Blank

and so on.

For each Row, both Col. B and C can be blank but both of them can not be non
blank. In Columns D & E, I want a look up formula which returns the
following results:

Col A Col. B Col. C
Col. D Col. E
Row 1 Employee Name 1% 7%
Row 2 Williams 5 Blank
1% 5
Row 3 Peter Blank 42
7% 42
Row 4 David Blank Blank
Blank Blank


I need this for a Paystub Report in my excel 2007 payroll workbook. Under a
particular head some employees are charged 1% of their basic pay, some pay
7% and other pay nothing.

Any help will be highly appreciated.

TIA.

Rafeek.