How to compare and move false information to another cell

H

honjoann

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
 
D

Don Guillett

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.
 
P

Paul

In N3 use the formula:

=IF(A2=B3,A4,IF(A4=B3,A2,""))



I am trying to compare A2 and A4 to B3 if b3 equal A2 then move A4 t
N3 if
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I add a formula or function to Vlookup? 1
Average function for letters 3
VBA Coding Help for Beginner 0
Column misalignment 0
cell references do not update correctly when moving too much data 0
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Using checkbox to change cell color 2
Compare last digit in 5 cells for match 0

Top