Hi all, its great to be apart of a good excel community now. I am about to pull my hair out on this one. I have been researching forever on what to do. I am trying to make an inventory spreadsheet of some toy figurines that I have and each time i click on a drop down to narrow down the next drop down to only those that apply in the given set. I have the entire table listed on ItemLookUp and want it to reference off that table on filling out the Home Contents Inventory sheet. Any ideas on what I am doing wrong? I am at a lost........ See attached
Please see below. BTW i am operating excel on a MAC if that helps to diagnose the problem. Thank you ahead of time for any help provided.
https://www.dropbox.com/s/f37bnlh9do...d%29.xlsx?dl=0
Jas
Also posted here https://www.excelforum.com/excel-formulas-and-functions/1237012-dependent-dropdown-list.html
Please see below. BTW i am operating excel on a MAC if that helps to diagnose the problem. Thank you ahead of time for any help provided.
https://www.dropbox.com/s/f37bnlh9do...d%29.xlsx?dl=0
Jas
Also posted here https://www.excelforum.com/excel-formulas-and-functions/1237012-dependent-dropdown-list.html
Last edited by a moderator:
