|
East Central Ia | I can’t look at your spreadsheet atm but are you using the VLOOKUP function at all?
I spent a bunch of time rewriting my spreadsheets this winter to simplify using them from year to year.
I would just make a full array in your data tab that has all the information you want for each product in a separate column. Then use the VLOOKUP function to pull all the information you want for each product once it’s selected in your drop down menu.
If I remember tomorrow I will attach a copy of one of my spreadsheets for you to look at.
Otherwise google excel VLOOKUP it will do everything you are wanting.
I use nested IF statements but they can get out of hand pretty quick lol. I mostly use if/then statements to return a “” (blank) for instance... IF(dropdown box cell = “None”, “”, return some data here if dropdown box is anything except None)
Clear as mud?
Edited by bleedred 2/22/2019 21:22
| |
|
Need Help with Dependent Drop Down List in Excel
