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.
|