Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLOOKUP and non sorted lookup arrays (2000 sp3)

    Hello all,

    I have the following data and trying to figure out the best way to tackle it with "excel magic".
    Sheet one column E contains 6 rows which I want to use as lookup values.
    Sheet two Column G contains 6 rows where in non-alphabetical order the values may appear. They are not ordered nor sorted
    Based on this I want to populate within Sheet One column B the values from sheet two column C and if there is not a value at all in the array to just leave the cell blank.
    Can the lookup array contain breaks between rows?

    I really appreciate any help.

    Kind Regards,

    Dawn


    I have included a basic example of this in my attachment.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VLOOKUP and non sorted lookup arrays (2000 sp3)

    How about this in B2
    =IF(ISERROR(MATCH(E2,Table_2!$G$2:$G$6,0)),"",INDE X(Table_2!$C$2:$C$6,MATCH(E2,Table_2!$G$2:$G$6,0)) )

    Copy it down the rows

    Steve
    PS. Yes the lookup table may contain blank rows.

  3. #3
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP and non sorted lookup arrays (2000 sp3)

    In the immortal words of Mike Myers I am truly not worthy. :-)
    Worked perfectly! Now to transpose that to a HUGE spreadsheet and see if I break it.

    Thank you very much.

    Kind Regards,

    Dawn Beck

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VLOOKUP and non sorted lookup arrays (2000 sp3)

    BTW, welcome to the Lounge.

    I am glad I could be of help.

    Post back if you have problems using it, need more explanations of the workings, or have additional questions.

    Steve

Posting Permissions

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