Data Validation with UNIQUE List as Source

[a68tbird]

Hello All -
I'm attempting to create a dropdown list of values using a named range source, which is itself created by applying UNIQUE to a column of values. So:

Named range is Vendor:

In the Data Validation configuration, I've tried just entering as source:
- Vendor
- INDIRECT("Vendor")
- INDIRECT(Vendor)

These all end up in errors. Is there a way to do this? I even tried using =UNIQUE(tblVendors[Vendor]) as the List source, but that didn't work either.

Thanks for any ideas.

 

[Fluff]

You would need to put the formula in a cell & then refer to that.
So if you had the formula in E2 you would use =E2#

 

[a68tbird]

Wow! Look at home simple that is! Thanks very much!

 

[Fluff]

You're welcome & thanks for the feedback.