Results 1 to 4 of 4

Thread: Value based selections from a table

  1. #1

    Value based selections from a table

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear XL Guru/s,
    Our objective is to be able to put a dollar value into a cell, then select a client type (essentially a condition), and then either run a macro or formula/s that will populate a table based on select information from another table.

    To be clearer, the smaller the dollar value in the reference cell mentioned earlier, then the fewer selections in the new table (set by rules of % value of the product compared to the overall $ value). The new table will then shows the recommended products that the client should consider purchasing.

    Any help or comments would be very much appreciated.


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    You need to be a lot more specific, talk about the specific data inputs and the data outputs, give some examples, post aworkbook.

  3. #3
    Thanks for the reply Bob. I'm new on excel guru so appreciate you setting me straight. I'll put together workbook and clear explanation and post on this thread.


  4. #4
    Bob and others,
    I've attached a workbook with some instructions.

    To clarify, I'm wanting to build this model to generate results for an assignment for my postgrad degree in finance. I've selected the assignment and it is portfolio construction. Any assistance would be appreciated.
    Attached Files Attached Files

Posting Permissions

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