Arrays - Check strict (not approximative) match

[Daniel_Sebastian]

Hello Everybody,

I would like to ask if is there a function which looks for exact value of an array. I have been working with the function Filter, which you can see in the next statement to compare a name of a channel with the ones of an array called "ChannelsToKeep":

If UBound(Filter(ChannelsToKeep, ChnName(i)))=-1 Then

But For example if my array contains the values ("mally", "kate", "becks") and I look for "ally" then it will match with "mally", but I don't wish that.

Any suggestion is welcome.

Thank you very much

[Daniel_Sebastian]

I realized that the method StrComp is the most appropriate for check strict match between two texts. So it will be very useful for someone who needs that in the future.