Forum Discussion
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 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 |
2 Replies
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!
