+ Reply to Thread
Results 1 to 3 of 3

Allocating An Amount to Different Percentages According to an ID Number

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    11

    Allocating An Amount to Different Percentages According to an ID Number

    The attached Excel contains a short sample of an allocation I'm working on. I would like to allocate an amount in one column according the percentages in another column. The two columns are link by an ID number. I’m trying to use the IF function which seems to be working somehow but gives an error message after copying he formula down the column.

    Thanks in advance for any suggestions.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Allocating An Amount to Different Percentages According to an ID Number

    Place this formula in G2 and then copy down column : =VLOOKUP(E2,$B:$C,2,FALSE) * F2

  3. #3
    Registered User
    Join Date
    10-24-2012
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Allocating An Amount to Different Percentages According to an ID Number

    WOW! It is simple but works perfectly. Thank you nimrod!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. allocating a total amount based on conditions
    By Jules Pop in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2015, 01:25 AM
  2. help re allocating a number over many budgets
    By iwuvnumberz in forum Excel General
    Replies: 1
    Last Post: 08-19-2015, 02:13 PM
  3. help re allocating a number over many budgets
    By iwuvnumberz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2015, 05:01 AM
  4. Need help with allocating Revenue to months only for Year 2014
    By Saurabh.bhole in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-03-2014, 06:36 PM
  5. How do I calculate different percentages depending on the amount?
    By woofer*wolf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-13-2012, 04:49 AM
  6. Predicting sales percentages based on amount of calls taken
    By zartanian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2012, 01:34 PM
  7. calculating different percentages depending on amount
    By pgruening in forum Excel General
    Replies: 6
    Last Post: 10-24-2005, 01:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1