Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Formula to find Value

    I have group numbers in Col C for eg 1.1, 1.2, 1.3. I have %'s in Col D. I would like to look up a % based in the group number. The % will be inputted for the first group member in eac group in col D and I would like a formula to look up the balance using a formula

    I have attached sample data

    Your assitance will be most appreciated
    Attached Files Attached Files

  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
    I would place the values to lookup in a new location (like A2:a4 for 1.1 to 1.3 and B2:B4 for the values) and then use a formula like:
    =VLOOKUP(C2,$A$2:$B$4,2,0)

    to place them in col D.

    Steve

    PS
    Another option (and it may be what you are thinking about) is to use the formula in D2:
    =VLOOKUP(C2,$C$1:d1,2,0)

    and copy it down the column. They will all by #NA errors until you enter a value for the first one of each in the list. Once you manually enter the first one, the others will be filled out.
    Last edited by sdckapr; 2012-04-21 at 15:21.

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Howard,

    Could you please provide a sample of what the output should look like for the formula and where you want to put the formula.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Steve & Retired Geek

    Thanks for your replies.

    Steve, I have used your first option & it works perfectly

    Regards

    Howard

Posting Permissions

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