Unique using wildcard

[cogswel__cogs]

I am using the below function in building for some dynamic dashboards.
Was hoping to use * for wildcardin the critera thinking that if A1 = * criteria would be met.
Is there a way to do that or do I need to put in if with a true in second part of if?
All help is appreciated.

=UNIQUE(FILTER('wRVU Projection'!D14:D345,('wRVU Projection'!C14:C345 = Data!A1)))

 

[FormR]

Hi, you could try:

=UNIQUE(FILTER('wRVU Projection'!D14:D345,ISNUMBER(SEARCH(Data!A1,'wRVU Projection'!C14:C345))))

 

[cogswel__cogs]

Worked like a dream.
Many thanks