Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Los Angeles
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting changes data (2000)

    I have two workbooks. One contains a large list of names with numbers in various columns. I have LINKED some numbers related to a name from the first workbook to their corresponding name in a second workbook. BUT - when the first workbook is sorted on various columns, the link on the second worksheet does not update. (I know moving a cell would keep the data correct, but SORTING ? ALL IS LOST?!)

    So then, I tried giving each linked cell (in workbook 1) a NAME (DavidTotal, MarkTotal, etc.), and linked to those cells. When you sort, the named cells do not follow the row. (DavidTotal was in C45, and after sorting, David's row is now row 32 let's say, but DavidTotal is still cell C45).

    VLOOKUP solutions won't work, because with VLOOKUP the column must be sorted for the function to work, and the lookup column will be unsorted at times when sorting by other columns.

    ANY IDEAS? Thank you. (Not sorting is the only answer I have at this point, but as numbers change, workbook 1 needs to be in this new order.)

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Sorting changes data (2000)

    VLOOKUP will correctly reference unsorted data if the last parameter is given as false, as in =VLOOKUP(lookup_value,table_array,col_index_num,FA LSE). The helpfile is a bit confusing about this parameter.

    If this doesn't solve your problem, post back a sample of what you are doing.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Los Angeles
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting changes data (2000)

    This works great! THANK YOU.

Posting Permissions

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