Hi

There is no built-in way to accomplish this task for Data validation.

Use could try a ActiveX combo box.

May be this link will be useful. Auto Complete for Data Validation