Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Comparing 2 columns of data

    Rows a1-a143, I have a master list of contract numbers. In rows g149-g179 I have another list of other contract numbers, some that may or may not be on the master list. What I would like to do in h149-h179 is return a "Not Found" message if the contract number in the corresponding cell in column g is not found in the master list at a1-a143. Any help? I have seen it before utilizing the "Match" function, but couldn't locate it.
    Thanks in advance.

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,168
    Thanks
    47
    Thanked 978 Times in 908 Posts
    In H149 enter this: =MATCH(G149,A$1:A$143, )

    cheers, Paul

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts
    building on Paul's post:

    in H149, enter: =IF(ISERROR(MATCH(F8,$A$1:$A$3,)),"not found","found")

    and fill down to h179.

    Of course, you can change the messages in the IF test.

    Fred

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks guys.

Posting Permissions

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