Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data location in lists (2000 sp3)

    Greetings!
    I have a situation were I have a list of identifiers that may or may not be the actual name of a person. The identifier is repeated throughout the file(in the same column A). I have another list that did not start out in Excel. It was brought in as text. The list has in column C lists of IDs and names, then a space. Column D is shifted UP one cell to align the ID in column B with a Name in column C.

    I need to check column A against column C, when a match is found grab in coulmn C, grab the contents of corresponding cell in column C (same row) and place it in column B next to the identifier.

    I hope this is clear....

    Thanks,
    Brad

  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: data location in lists (2000 sp3)

    Are you looking for in B1:
    =VLOOKUP(A1,$C$1:$D$432,2,0)

    Copy it dwon to B2:B142

    Steve

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data location in lists (2000 sp3)

    Steve,

    Sorry for the delay, I have been out for vacation.

    I will try the suggestion,

    Thanks,
    Brad

Posting Permissions

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