Forum Discussion
rjjaxfl
Mar 21, 2025Copper Contributor
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 ...
HansVogelaar
Mar 21, 2025MVP
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?