Do you mean: =IF(OR(A2=B3,A4=B3),A4,A2) in N3?
--
Regards
Dave Hawley
www.ozgrid.com
"honjoann" wrote in message
news
I am trying to compare A2 and A4 to B3 if b3 equal A2 then move A4 to N3
if
not then move A2 to N3.
I am new to using formulas in excel