Excel help data validation if function

New Contributor

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 pick #1 i would like it to return to me the date related to #1 and not the number itself,,, anyone

 

Column1Column22022-12-16

 
12021-12-31 
22022-01-14 
32022-01-28 
42022-02-11 
52022-02-25 
62022-03-11 
72022-03-25 
82022-04-08 
92022-04-22 
102022-05-06 
112022-05-20 
122022-06-03 
132022-06-17 
142022-07-01 
152022-07-15 
162022-07-29 
172022-08-12 
182022-08-26 
192022-09-09 
202022-09-23 
212022-10-07 
222022-10-21 
232022-11-04 
242022-11-18 
252022-12-02 
26 
2 Replies

@TJayC 

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.

Thank you, i was looking for another more complicated way lol sorry end of day and my brain is bla!