+ Reply to Thread
Results 1 to 2 of 2

Populating cells based on dependent drop down lists within a table

  1. #1
    Registered User
    Join Date
    05-03-2021
    Location
    Birmingham, England
    MS-Off Ver
    Microsoft H&B 2019
    Posts
    1

    Populating cells based on dependent drop down lists within a table

    Hi,
    I have attached a sample costing sheet where I am attempting to use dependent drop down lists within a table. I have managed to create these and I am quite please with how they function. The next part is what I am struggling with, I am unable to automatically populate the 'cost per unit' and 'cost per weight' cells based on the selections from the data validation lists.
    if anyone could suggest a formula that would work it would be greatly appreciated.
    Cheers, Matt.
    (I've never posted on here before so I'm hoping I've done everything correctly, hopefully there should be a spreadsheet attached..)
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,597

    Re: Populating cells based on dependent drop down lists within a table

    Can you add expected results to your file please.

+ 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. [SOLVED] Dependent Drop Down Lists Based On A Cell Value
    By Jojothemonk3y in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2019, 08:01 AM
  2. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  3. Automatically populating a value based on several drop down lists
    By JStrawn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2015, 05:27 AM
  4. Dependent Drop Down Lists with Lookup in Table Formula
    By dannysporea in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2013, 12:27 PM
  5. [SOLVED] Return value based on 2 dependent drop down lists
    By arsene2conde in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 10-14-2013, 09:44 AM
  6. IF THEN ELSE based on Three Dependent Drop Down Lists (VBA)
    By vtsoldier2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2012, 09:56 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