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