Dropdown List Help

[benhickman]

Hi,

I really hope someone can help me make this drop down list.

I have a cell that a user will type in a acronym. Cell B1

I have a range of acronyms in a separate tab (about 700 of them).

I would like the user to presented with a drop down list of cells within the range that contain those three characters and any other cells that has any other characters after what they have typed. Like a wild card.

Is this possible?

Please please please help.

Thank you

 

[benhickman]

I have literally just cracked it!

Thank you