Cross match data in Col A v/s Col B and display match in Col 3
 

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?

Cross match data in Col A v/s Col B and display match in Col 3
 

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?

Cross match data in Col A v/s Col B and display match in Col 3
 

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?

I want to match same values in Col A taking Col B as a pointer and
output the result of the match found in C

Cross match data in Col A v/s Col B and display match in Col 3
 

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