| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| match data in 2 sheets then display true/false from vlkup | Excel Worksheet Functions | |||
| Need help with match/cross reference two GAINT excel databases!! | Excel Discussion (Misc queries) | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Linear Mode
