Search Suggestion with formula not working

Hi laansesu,

It sounds like you want to build a list of values for a dropdown that are unique. I'd do this using an advanced filter with a unique box checked. I'd then use a dynamic named range for the dropdown list. If you'd supply a sample workbook it would be easier to explain...

See my example workbook where I do what I think you want.