+ Reply to Thread
Results 1 to 3 of 3

Matching 2 columns of numbers

  1. #1
    Registered User
    Join Date
    06-04-2009
    Location
    Essex
    MS-Off Ver
    Excel 2007
    Posts
    15

    Matching 2 columns of numbers

    Hello everyone, really need your help

    This to me sounds so simple, but i've been using excel so much in the past month, my brain has turned to jelly. I am at the end of my tether with the job i am doing.
    Basically, in the picture, you will see 2 columns with numbers in them. I need to know which numbers match and which ones dont. The list of numbers on the left goes down for ages, while the list on the right probably goes only halfway.(twice as many numbers on the left basically)
    \1
    some of the numbers on the right might have duplicates, but i dont think thats a problem.
    The end result, i would like the numbers that match to be highlighted.
    to sum it up, the numbers on the left are product numbers, the numbers on the right are image names that i got from a txt dump of the folder with the images in. I need to match the image names with the product numbers to see which products i have pictures for. This seems like such a long winded way of explaining it. Can anyone help me before i lose my hair?

    Thanks in advance

    Steve

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Matching 2 columns of numbers

    Try:

    =Isnumber(Match(I2,A:A,0)) copied down

    or

    =Isnumber(Match(A2,I:I,0))

    depending on what you want to match to what list...

    TRUE means matches found.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    06-04-2009
    Location
    Essex
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Matching 2 columns of numbers

    thanks for the extremly fast reply. Your first simple formula worked a treat. Thank you very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1