Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation from Database (not sorted)
Hi to everyone,
Does anyone know how to validate a List from a Database not sorted? the point is, In cell A1 I type a file number to get in B1 a dropdown list with the products related with that file. The list (validation) is coming from a Database which is not sorted since I have to update it each day (lets say I have the database in columns D and E {D(File Number) and E(Product number)} Anyone knows how to get the list from the database? Thanks in advance bc this is driving me really crazy!!! Regards, Faico |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to External Database | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Duplicates in database validation | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |