Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Lookup (?) (2003)

    Situation: On worksheet 1, I have product names in every other cell in row 1. In row 465, I have the product's price in the same column as the product name. On worksheet 2 I have the product names listed in the same order as on worksheet 1 but in column 1. What I would like to do is put the corresponding price in column 2.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Lookup (?) (2003)

    Works fantastic!
    Thanks Steve.

  3. #3
    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: Lookup (?) (2003)

    <P ID="edit" class=small>(Edited by sdckapr on 16-May-08 12:27. Forgot the dollar signs for the index)</P>Does this work?

    =INDEX('Worksheet 1'!$A$465:$A$928,MATCH(A1,'Worksheet 1'!$A$1:$A$464,0))

    Steve

  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: Lookup (?) (2003)

    I forgot the dollar signs to lock the index range. I have edited my original post...

    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
  •