Forum Discussion

Mike_Pellock610's avatar
Mike_Pellock610
Copper Contributor
Sep 13, 2023
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 in the drop down.  The cell that uses the items does a Vlookup from data associated with the items in the list.  The problem is the new items in the list are returning #N/A or data from a different item in  the list.  Can not figure out why.

thanks 

MIke

excel
  • mtarler's avatar
    mtarler
    Sep 13, 2023
    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

2 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Sep 13, 2023
    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

Resources