How to list data in row based on selection from another cell?
I have ranges named:
Categories [A7..A8]
Plans [cells C2..F2]
VP_Plans [cells G2..L2]
Cell A3 is set as a drop down using data validation using Categories. What I would like is when select a category, it would fill in either Plans or VP_Plans in cell C5, D5, etc. based on the category chosen.
I can do this using IMPORTRANGE in google sheets but for a variety or reasons need to be able to in Excel.
Note that the range Plans is shorter than VP_Plans.
Help?
Bookmarks