1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Help

Discussion in 'Microsoft Office Specialist (MOS)' started by ThomasMc, Jun 7, 2007.

  1. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    I'm having a little problem trying to work out how to get excel to query 2 worksheets and return unmatched/Orphan records

    Setup

    WS1 - Invoices
    WS2 - Deliveries
    WS3 - NoDeliveries

    i want to display only records that have an invoice but no matching delivery. I would appreciate an help on this matter as my excel knowledge isn't upto much ;)
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  2. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    found a formular that give me the results i was looking for

    Code:
    =IF(ISNA(MATCH(K185, Deliveries!U$1:Deliveries!U$2000, 0)), "NDN", "Found")
    
    Thanks
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)

Share This Page

Loading...