+ Reply to Thread
Results 1 to 4 of 4

MATCH

  1. #1
    Mrbanner
    Guest

    MATCH

    Thanks Formula searches the way I need
    But for some reason it is not Inputting the Correct Information into AG

    Cells
    =3DINDEX(Sheet1!$AG$1:$AG$8000,MATCH(1,($D$1:$D$8000=3DSheet1!D1)*($J$1:$J$=
    8000=AD=3DSheet1!J1),0))

    With the data I have it will not be in the same order all the time and
    items and lines will be removed and added. I think this code is for if
    the line stay the same


    For example
    On Sheet 1
    D=3D Account Number
    J=3D Product Code
    AG=3D Notes


    Sheet 2 is the same
    D=3D Account Number
    J=3D Product Code
    AG=3D Notes


    But the information inside the cells will mostly be different
    And in different order.
    What I needs that if Sheet1 (D & J) upto 8000 lines =3D (Sheet2 (D & J)

    upto 8000 lines then Sheet 2 (AG) =3D Sheet 1 (AG)


    Sorry hard to explain
    In a nut shell
    Sheet1 (D&J) LINE 5)
    Sheet2 (D&J) LINE 800)
    Both Match I have notes typed In AG(Sheet1)
    Now I need these notes to be shown in Sheet2(line 800) now?


  2. #2
    Max
    Guest

    Re: MATCH

    Posted this response in your original thread ..
    ---------
    "Mrbanner" wrote:
    ....
    > Sheet1 (D&J) LINE 5)
    > Sheet2 (D&J) LINE 800)
    > Both Match I have notes typed In AG(Sheet1)
    > Now I need these notes to be shown in Sheet2(line 800) now?


    Think this orientation should now be correct ..

    In Sheet2,

    Put in AG2, and array-enter:
    =INDEX(Sheet1!$AG$2:$AG$8000,
    MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8000=J2),0))
    Copy AG2 down

    And perhaps better with error-traps to return blanks ("") for non-matching
    lines, etc, we could put instead in AG2, array-enter, and fill down:

    =IF(OR(D2="",J2=""),"",
    IF(ISNA(MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8000=J2),0)),"",
    INDEX(Sheet1!$AG$2:$AG$8000,
    MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8000=J2),0))))
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



  3. #3
    Mrbanner
    Guest

    Re: MATCH

    thNkz man works great =IF(OR(D2="",J2=""),"",
    IF(ISNA(MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8000=J2),0)),"",

    INDEX(Sheet1!$AG$2:$AG$8000,
    MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8000=J2),0))))


  4. #4
    Max
    Guest

    Re: MATCH

    You're welcome !
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



+ 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