Dynamic Data Validation List from a Table

**omegaboost** · 08-21-2021, 10:57 AM

Dear All..
Please help to create a dynamic data validation list from the data in the "ITEM" table so that in cell F2 there will be a data validation list that matches the date in cell E2, the data validation list in F3 will also match the date in cell E3 etc. In addition that the data in the ITEM table will grow steadily every day.

Thank You

**Vraag en antwoord** · 08-21-2021, 11:36 AM

Create a defined name with CTRL + F3 and use the following formula in the validation. It only works if the table is sorted by date.

Please Login or Register  to view this content.

**omegaboost** · 08-21-2021, 07:04 PM

Dear Vraag en antwoord..

Thank you for your help..That's exactly what I needed.

Dynamic Data Validation List from a Table

LinkBack

Thread Tools

Rate This Thread

Display

Dynamic Data Validation List from a Table

Re: Dynamic Data Validation List from a Table

Re: Dynamic Data Validation List from a Table

Thread Information

Users Browsing this Thread

Similar Threads

Dynamic Drop-Down List Data Validation Issue for Multi-Rowed Table

[SOLVED] How can I add a new item to a dynamic validation list without adding to source table

[SOLVED] not showing duplicates in data validation list from dynamic table

Restrict data validation list selection based on another table - dependent data validation

Dynamic Data Validation List Using Pivot Table

Dynamic Validation List from DB Like Table

[SOLVED] Data Validation List to Return Variable/Dynamic Data based on Reference Table

Bookmarks

Bookmarks

Posting Permissions