find in array and get all related value

[luca90]

I have an array similar

1 2 3 6 7 8 9 aaaaa
2 5 8 7 9 4 5 bbbbb
...
we gt 56 yu 89 d5 fr ccccc

how to search in array to the last item based my_var=bbbbb

In this case return:
2 5 8 7 9 4 5

you can know:
not possible duplicates in last item of array

[RhinoBull]

Since you've been doing programming for awhile (since 2005) no sample code for you, only hint:

1. loop through array (For - Next or Do - While/Until);
2. use InStr or InStrRev function to find a match;
3. If match is found use Left or Mid function to get the output.