Previous Topic Next Topic

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

Closed
Pooja - May 27, 2016 at 10:28 AM
 Blocked Profile - May 27, 2016 at 04:16 PM
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


1 reply

Answer 1 / 1
Blocked Profile
May 27, 2016 at 04:16 PM
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!
0