Finding the position of a value in an array

I am aware that you can use Match to find the position of an entry in an array, and the following code works as expected, returning an index of 4:

Please Login or Register  to view this content.

The problem is if I don't know the EXACT text that will appear in the array, but only part of it. I am wanting to do something like the VBA .find lookat:=xlpart operation, but on an array rather than a worksheet.
The following code will return with the "Not Found" message.

Please Login or Register  to view this content.

Other than looping through the entire array and doing a Like test on each entry, is there a more elegant (ie. faster) way of searching an array when you only have part of the string?

Thanks

Add some wildcards.

Please Login or Register  to view this content.

Ah! That simple

I couldn't see anywhere that Index supported wildcards, and then managed to forget to actually try it...

Thanks!