Formulas cannot MOVE data. They can only return values so you would have to
have an appropriate formula in each cell or use a macro to move the data as
desired.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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