Compare 2 Columns, if they are the same, display the text from a 3rd column

E

elaine

Hi,

I have a problem. I would like to update some old ID with new ID and
new names.

I have 3 columns at the moment, Say ColA is the old ID numbers, Col C
is new ID numbers and Col B are names of the new ID numbers

I want to check if the ID numbers in Col A is equal to Col C. If this
is the case, I want to display the relevant names in Col B.
otherwise, display 0.

Can i do a conditional formatting where if A1=C1, display B1? otherwise
zero?

But ColB and ColC are relevant to each other, how can i do that?

Thanks very much.
 
S

Special-K

Dont need Conditional Formatting, just set a cell say in D column

=IF(A1=C1,B1,0)

and copy the formula down the D colum
 

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

Display a list of unique values from a column with multiple instances 4
Help comparing data in 2 columns and finding same data in both 21
match dates in two columns get value from third 1
IF function 4
Combine 2 rows if name is same in Column B & C on both 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Comparing two columns and returning value from another column 1
Compare data set 1 with data set 2. Add to data set 2 if not found 0

Top