Drop down list with suggestion

[Ashish@1987]

Hi All,

Can you please help me to create the drop down list with suggestion.

I have a list of more than 500 line item and i want to create a a drop down list which will give suggestion in sheet 1 based on the master data available in sheet 2.

Attaching the sample file for your reference.

Thanks in advance.

Regards,
Ashish

 

[Chihiro]

Check link in Nebu's post below.

http://chandoo.org/forum/threads/search-in-data-validation.29889/#post-178542

 

[Villalobos]

another proposal with helper columns