How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

HelloI need a formula that if a cell has a drop down list

Customer Question

I need a formula that if a cell has a drop down list and the users chooses "a" then use the multiple dependant drop down lists, if user selects "b" then populate the values in the above for some cells and for other not
Submitted: 1 year ago.
Category: Programming
Customer: replied 1 year ago.
I also want to add that I'm working in Excel 2016 on Mac
Here are specifics
Cell D6 has two drop down options Master Task and sub task
Cells E6 and F6 are both drop downs that feed dependent drop downs in G6 and H6
Cell I6 is a dependent drop down based only on F6If Master Task is selected I want all drop down and dependant drop down lists to function as they do now. If Sub Task is selected then I need G and H to remain functional but for E, F and I they need to copy the values in the above line.
Customer: replied 1 year ago.
I tried to send the file but it will not accept a macro enabled workbook. When can I expect an answer?
Expert:  Richard replied 1 year ago.
Hi there Laura and welcomeCan you please go to http://ge.ttUpload the file there and provide me please the download link it gives to you
Customer: replied 1 year ago.
Expert:  Richard replied 1 year ago.
ok, I see no drop downs yet, should they already be there?
Customer: replied 1 year ago.
They are but are but are based in other column selections. You have to select type and lob
Expert:  Richard replied 1 year ago.
ok, I do not think your message came through correctly.On which sheet are they?
Customer: replied 1 year ago.
What columns are you trying to populate or are you looking for the dependant drop down lists that create the options in the drop down lists?
Expert:  Richard replied 1 year ago.
I need to know, on which sheet are the dropdowns as I see none on any sheets
Customer: replied 1 year ago.
i need to know which drop downs you want to look at
Customer: replied 1 year ago.
Why was I charged when there was no answer? I believe I was to be charged $5 only if the answer was not acceptable. Since there was no answer I find this to be "not acceptable".