Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Sheet 1 has 2 columns of text in 10 rows. Column A contains a master list of descriptions of merchandise, and column B contains the respective abbreviations of the descriptions in column A.

    Sheet 2 currently has 1 column with hundreds of rows. In each cell of the column are the descriptions that are listed in column A on sheet 1, but in various, random order.

    What I would like to do is in column B on sheet 2 insert the abbreviated description that corresponds to the description in column A in sheet 2.

    Any ideas?

    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    In Cell B1 of sheet2 put
    =VLOOKUP(A1,Sheet1!A:B,2,FALSE)
    or if you really do only ever have exactly 10 rows then
    =VLOOKUP(A1,Sheet1!A1:B10,2,FALSE)
    Then drag B1 down to fill column B in sheet2

    [attachment=83212:Vlookup.xls]
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='StuartR' post='769283' date='05-Apr-2009 13:39']In Cell B1 of sheet2 put
    =VLOOKUP(A1,Sheet1!A:B,2,FALSE)
    or if you really do only ever have exactly 10 rows then
    =VLOOKUP(A1,Sheet1!A1:B10,2,FALSE)
    Then drag B1 down to fill column B in sheet2

    [attachment=83212:Vlookup.xls][/quote]


    Thanks Stuart

Posting Permissions

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