compare two cells in excel and if matches need to print its adja Closed

Question

Hello, 

I want to compare two cells in excel and if matches need to print its adjacent value in next column.

for example: I need to compare column A to B if A=B then its corresponding value from column C should get print in column D


Configuration: Windows 7 / Mozilla 11.0

ac3mark · Answer

In column D use this : =IF() 

The IF function is as follows:
=IF(LOGIC_TEST,TRUE,FALSE)

So in d enter =IF(a=b,c,"does not match")


It really is that simple!

Compare two cells in excel and if matches need to print its adja

1 response

Similar discussions

Subscribe To Our Newsletter!