Results 1 to 4 of 4

Find % distribution based on data in lookup table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    Office 365
    Posts
    433

    Find % distribution based on data in lookup table

    Hi,

    I have 6 items ( Their % of the total is shown in the table)

    These items will go in 5 boxes

    The items which will go in each box is shown in a lookup table

    Based on this lookup table, I need to generate a table which shows % distribution of each item in each box.

    I have done the calculations using helper tables and columns , but would like to receive a solution which will avoid usage of helpers.

    Sample file attached.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup 2 data points then into a table to find the the relevant cell
    By king10001 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-15-2019, 08:20 AM
  2. [SOLVED] lookup and return data from one table to another based on a cell reference.
    By Destiny1990 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2018, 07:50 PM
  3. Find and Replace based on lookup table
    By batchjb69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2017, 08:21 AM
  4. [SOLVED] Using A Formula To Lookup Data From Another Table Based On A Reference Column
    By TheBaileyBrew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2017, 09:41 PM
  5. Macro for data distribution on a table
    By Relapsed in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-07-2009, 06:40 AM
  6. How do I use lookup to find data based on 3 criteria?
    By jerickson in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-03-2008, 09:26 AM
  7. entering data based on a lookup table
    By rgdwar1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2008, 09:03 AM

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