Compare two columns and display value in 3 cloumn
 

Hi
I have data in Excel Sheet in the following way

A B C
123 234
1 2
2 123

The data in Column B have to compare the value in Colmun A and if found the
value have to be displayed in Column c
Can you please me regarding htis issue.

Compare two columns and display value in 3 cloumn
 

are you looking for sth like this:

=IF(COUNTIF($A$1:$A$100,B1)0,B1,"")



On 12 Gru, 17:19, Raj wrote:
Hi
I have data in Excel Sheet in the following way

A * * * * B * * * *C
123 * *234 *
1 * * * *2
2 * * *123

The data in Column B have to compare the value in Colmun A and if found the
value have to be displayed in Column c
Can you please me regarding htis issue.

Compare two columns and display value in 3 cloumn
 

=If(ISNUMBER(MATCH(B1,A1:A3)),A1,"Not found"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Raj" wrote:

Hi
I have data in Excel Sheet in the following way

A B C
123 234
1 2
2 123

The data in Column B have to compare the value in Colmun A and if found the
value have to be displayed in Column c
Can you please me regarding htis issue.