Forum Discussion
Can I Use the VLOOKUP Formula to Return a Data Validation Drop Down List?
No, you can't use VLookup, but you could still add data validation. The caveat is that you can't have user input and a lookup formula in the same cell, so you would need to add a column for user selection from the data validation list. Then, using an IF formula in the instructor field, you can perform a lookup when there is only one instructor, or pull from the user's selection from the data validation when there is more than one.
I feel like I have a similar question. I have inherited a spreadsheet with lots of formulas and macros. It's effectively a new employee form that auto populates as soon as a position is selected from a drop down.
I am grabbing it from a step before and using MS forms and Power query to get 5 basic bits of info and want them to then fill the form and autopopulate from that step.
My first most basic observation seems to be that putting "=othersheet$A$2" in the dropdown controlled cell creates an issue, even if what it displays is in the dropdown parameters.