Forum Discussion
Solved
Drop down in excel
I created a drop down that used a list of item numbers. Initial drop down worked great. Now I wan to add items to the list. I added them to the list. Updated with Data Validation to include them ...
- very hard to diagnose without the sheet or at least each of the relevant formulas and sample/example data. That said it sounds like maybe the original list was in order (e.g 10,20,30,40...) and then you added values out of order but your VLOOKUP isn't defined to find an exact match (the 4th parameter needs to be set to 0 or FALSE). You may also consider using XLOOKUP if you have Excel 365
very hard to diagnose without the sheet or at least each of the relevant formulas and sample/example data. That said it sounds like maybe the original list was in order (e.g 10,20,30,40...) and then you added values out of order but your VLOOKUP isn't defined to find an exact match (the 4th parameter needs to be set to 0 or FALSE). You may also consider using XLOOKUP if you have Excel 365
thanks. Looks like false is the answer.
Thank you!
Thank you!