Forum Discussion
Trying to autopopulate data in one column based on data in different column
Hello,
Data in column A is selected from a drop-down (data validation list).
Data in column B is based on data in column A. For some entries in A there is only one choice (one-to-one) - I did this using VLOOKUP to select what to put in column B based on entries in column A from a reference sheet.
However, some entries in column A require a choice of a subset that could be in column B (one-to-many). Is there a way to have both, and for the one-to-one it just fills in the data and for the one-to-many it gives a drop-down to select the correct option?
Thanks
1 Reply
That would require VBA, so it would work only in the desktop version of Excel for Windows and Mac.
If that is OK, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
