Thread: Cross match data in Col A v/s Col B and display match in Col 3
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
aquaflow aquaflow is offline
external usenet poster
  
Posts: 14
Default 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
Reply With QuoteReply With Quote