Data Validation with searchable drop down

[ismailzkhan]

Dear Experts,

I am looking for data validation with searchable drop down. Attached excel having Database sheet with sellers list. In April sheet in Column E looking to have a data validation with searchable drop down. Please help.

Is there any way to have without VBA if not VBA also works for me.

Thanks in advance.

Regards,
Ismail

 

[navic]

If I understood you well, I have a suggestion in two ways without VBA

1st
Helper columns on the Database sheet
OFFSET formula for Data Validation

2nd
Named cell in the Database sheet for each item
Selection from the drop-down list when entering

Please see attached files

 

[ismailzkhan]

Hi

If I understood you well, I have a suggestion in two ways without VBA

1st
Helper columns on the Database sheet
OFFSET formula for Data Validation

2nd
Named cell in the Database sheet for each item
Selection from the drop-down list when entering

Please see attached files

Hi Navik,

Thanks for your reply and suggestions. Can this be achieved with a VBA. Because option 2 works for me but giving name to each cell is very tiresome work to do as Im having 1000+ line items.

Regards,
Ismail Khan