Dependent drop down list

rjcjason

New Member
Joined
Jul 6, 2018
Messages
1
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
 
Last edited by a moderator:

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,297
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top