Forum Discussion
excel drop-downs
Windows 10... I have several single and multi-column lists and tables. The result of the drop-down selected the entire table is displayed but only the a single line saved;
I what to save the entire table or list. The error MSG. The list source must be a delimited list or reference to a single row or column.
1 Reply
A data-validation drop-down will store only the value from a single column.
You can use XLOOKUP or VLOOKUP in the adjacent columns to retrieve the associated values from other columns.
If you need more help:
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?
