Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 141
  • Last Modified:

XLS Matching to columns

Hi all

   I’m not an XLS person and I have a file with 2 columns of names. What I need to do is match names in column A to names in column b  and print in column C the names of column A that have a match in column B something like the example below

John      Paul       Paul
Paul      John      John
dan      Margret       dan
margret      Peter      Peter
peter      Robert       Dan = no match in B
0
d_asselin
Asked:
d_asselin
1 Solution
 
Ken ButtersCommented:
I've attached a spreadsheet that has a formula in Column C that will use Vlookup function to accomplish what you want.

Here is formula in C1... then did fill down to C5.
=IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),CONCATENATE(A1," = No match in B"),VLOOKUP(A1,B:B,1,FALSE))

what this does is take the value of John in A1 and checks to see if it can be found in column B.  If it can be found in Column B, it evaluates to the name in column A.

If it cannot be found... it takes the name in Column a and says it cannot be found in B.
Book1--1-.xlsx
0
 
d_asselinAuthor Commented:
Perfect thank you

Dan
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now