I am trying to compare two cells in a row within a range on one worksheet
and return a value on another worksheet. Example: Cell A3 on Worksheet 1
has an IF statement the compares the cells in column A to the cells in
column C on worksheet 2. IF cell a3 in Column A is NOT blank check to see
if the cell c3 is blank. If both conditions are met then return a value to
A# on Worksheet1. I am having trouble getting the comparison name to work.

Thanks in advance.

R Weeden