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


Related:

1 response

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

Similar discussions

Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Comparing columns and returning value
ll -
kittu -

35 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses