First time here. I know how to create drop down lists, but I can't seem to link the other cells with other day based on the choice you make. For example you have a drop down list with items. You select an item on the list, and depending on the items it will pull up statistics that match that current item (the stats are somewhere else on the workbook).
Another example is if you have a list with item A, B, and C. You create a drop down list for it. When you select item A the statistics of type, cost, weight, all show up in the other cells. However if you select B, the statistics of B will show up. The type of statistics are all the same for all items, but the values are all different. So how does one match a value of multiple stats (each stat has a different cell), based on the item you select on the drop down list?
Bookmarks