Sep 09 2022 12:52 PM
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
1 | 2021-12-31 | |
2 | 2022-01-14 | |
3 | 2022-01-28 | |
4 | 2022-02-11 | |
5 | 2022-02-25 | |
6 | 2022-03-11 | |
7 | 2022-03-25 | |
8 | 2022-04-08 | |
9 | 2022-04-22 | |
10 | 2022-05-06 | |
11 | 2022-05-20 | |
12 | 2022-06-03 | |
13 | 2022-06-17 | |
14 | 2022-07-01 | |
15 | 2022-07-15 | |
16 | 2022-07-29 | |
17 | 2022-08-12 | |
18 | 2022-08-26 | |
19 | 2022-09-09 | |
20 | 2022-09-23 | |
21 | 2022-10-07 | |
22 | 2022-10-21 | |
23 | 2022-11-04 | |
24 | 2022-11-18 | |
25 | 2022-12-02 | |
26 |
Sep 09 2022 01:09 PM
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.
Sep 09 2022 02:00 PM