September 3, 2022
Is there a way to bypass Excel error by using 2 columns for a drop down list. The drop down list shoukd appear as below:
So I can list the code and the description of the code, because listing only the code (on the 1st column) is meaningless.
January 31, 2022
You can't use 2 columns to create a data validation (i.e. drop down) list. The way to achieve what you need is to use the code only and then a lookup function in the adjacent cell. That may be VLOOKUP, XLOOKUP or INDEX/MATCH depending on your Excel version.