Forum Discussion
Data validation in Excel
Hi all, I have a big problem. I am making some Excel shets for my work, and I am using some data validation lists. The problem is that I set up some lists and two days later, I did nothing, but t...
I created three new ones in your file
| Lookups | =Paramétrage!$I$59:INDEX(Paramétrage!$K:$K,MATCH("zzzz",Paramétrage!$I:$I)) |
| Saisie_horaire | =Paramétrage!$B$60:$B$80 |
| Tâches | =Paramétrage!$I$60:INDEX(Paramétrage!$I:$I,MATCH("ZZZZ",Paramétrage!$I:$I)) |
Basically the Match "ZZZZ" just finds the last cell in the column with any text it it, so it defines the row in the column to use for the end of the range.
Formulas tab > Name Manager > New >Enter name and then Paste he formula into the Refers_to box and click Close
Repeat for all three names.
The file I sent, already has that done and the validation has been altered on the 01.19 sheet in cells C6:J30 so you can test it there.
If you get stuck, feel free to email me direct at roger@technology4u.co.uk
