+ Reply to Thread
Results 1 to 3 of 3

Formula to find the value of a cell based on the selections made in two other cells

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel H&B 2013
    Posts
    14

    Formula to find the value of a cell based on the selections made in two other cells

    I am making a form with drop down boxes and auto fill to make things easier.
    I have one Box for the Company selection another box for the occupation selection and I need a formula to find a $ value based on the selections made in these two cells.
    If I could establish the actual cell reference of the selected data in the second drop down list that would help but a full solution would be great.
    The data will be much larger than this example and will live on a separate sheet.
    Your help is much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Formula to find the value of a cell based on the selections made in two other cells

    Try

    =SUMIFS(Table48[PORD],Table48[Client],B9,Table48[Trade],B14)

    With B9 and B14 being your drop down selections
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    11-28-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel H&B 2013
    Posts
    14

    Re: Formula to find the value of a cell based on the selections made in two other cells

    Thanks heaps ace short and simple.
    You're an Ace!

+ 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. I need a formula that fills one cell based upon a choice made in another cell
    By rayrudolph in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-29-2013, 06:35 PM
  2. [SOLVED] If two different selections made from drop down menu = to answer in new cell
    By randomfluky in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 05:54 AM
  3. VBA code to find and delete cell contents based on userform combobox selections
    By anfdrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2013, 04:13 PM
  4. [SOLVED] Entering a formula in a cell based on the selections in two other drop down lists
    By oddinho in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-26-2013, 04:13 PM
  5. Run different Macros based on what selections have been made in checkbox
    By vetteengr in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-13-2012, 01:13 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