On Jul 10, 11:56*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
In C1, =IF(A1=B1,"match","no match") and copy down.
--
David Biddulph

"aquaflow" wrote in message

...

I want to match data in Col A v/s Col B and display the exact match in
Col C. How can I do that?

Col A Col B Col 3
dog cat found
cat dog Found
rat bat not found
mat hat not found