Compare two columns to find out similar values and print in third column

 

Gurgaon

Hyderabad

Hyderabad

Delhi

Chandigarh

Chandigarh

Hyderabad

Indore

#N/A

Mumbai

Mumbai

Mumbai

kolkata

Delhi

Delhi

Srinagar

 

#N/A

Banglore

 

#N/A

Chandigarh

 

#N/A

 

Above we have two columns City1 and City2, we are comparing two columns City1 and City2, we have to find out the similar values that exist in Cuty1 column and below is the formulae

=INDEX($A:$A,MATCH(B1,$A:$A,0))

Copyrights 2017, www.expertsupdates.com