Oct 30 2021 07:41 AM
I would like to have one drop down box populate cells with different information determined by what is selected in the drop down box. For example;
If I select Tim from the drop down box the in row 3 I would like Tim's Information displayed.
Using the same drop down box if I select Don I want Don't information displayed in row 4, and so on through row 300.
Oct 30 2021 08:12 AM
You can use VLOOKUP (or XLOOKUP, if you have Microsoft 365 or Office 2021) to look up information for the person selected in the drop-down.
Oct 30 2021 08:18 AM
Oct 30 2021 11:06 AM
SolutionYou should use a data validation drop-down in column A, so that each cell can hold a different name.
The formulas in the columns to the right should refer to the cell in column A in the same row.
Oct 30 2021 11:06 AM
SolutionYou should use a data validation drop-down in column A, so that each cell can hold a different name.
The formulas in the columns to the right should refer to the cell in column A in the same row.