Hi All

I am trying to use the match function in order to find a look up value
(text) in an array of strings.
If there is an exact match, I need to return the index of the match - no
problem with match(lookup,array,0)
Now, if there is no exact match I need to return the index of the string in
the array that has the same first 3 characters as the look-up value.


EX.

array1:
abc123
abb123
abd123
abf123

lookup value
abb59595

i need the match function to return 2

Any help is greatly appreciated, and thanks for your time in advance!!

Stan