Forum Discussion
TJayC
Sep 09, 2022Copper Contributor
Excel help data validation if function
Hello all not sure how to formulate the questions but I would like to know if I can create a dop down list that when I pick the value it returns another cell value Example If in my drop down I ...
HansVogelaar
Sep 09, 2022MVP
You can't do that with Data Validation.
It'd be better to select the number and display it in the cell, and use a VLOOKUP or XLOOKUP formula in the cell next to it to return the associated date.
- TJayCSep 09, 2022Copper ContributorThank you, i was looking for another more complicated way lol sorry end of day and my brain is bla!