+ Reply to Thread
Results 1 to 4 of 4

need to find matching cells in 2 columns

  1. #1
    Registered User
    Join Date
    05-13-2005
    Posts
    2

    need to find matching cells in 2 columns

    Hi

    I have 2 columns of file names and I need to check if any from column B also appear in column A.


    Sorry if this has been asked before (and is a bit basci) but I wasn't sure what this type of function would be called so couldn't search for it.

    Thanks in advance.

    E x

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Use the match function. Suppose you want to check the value from column B in the column from A, enter in column C:
    =MATCH(B1,$A$1:$A$6,0)
    and then drag down

    If the value is found, then the result is the position of the value in the column A, otherwise it returns #N/A.

    - Mangesh

  3. #3
    Registered User
    Join Date
    05-13-2005
    Posts
    2

    Smile

    Fantastic!

    Wasn't sure it had worked but copied one from B to A and it picked it up, turns out there are no duplicates, damn more work for me

    Cheers

    E x

    p.s. for anyone interested - to get this to work i changed the 6 to the coloumn length of A

    =MATCH(B1,$A$1:$A$6,0)
    Last edited by riotstar; 05-13-2005 at 07:32 AM.

  4. #4
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Or simply use:

    =MATCH(B1,A:A,0)

    for the entire column A


    - Mangesh

+ 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