problems with MATCH worksheet function

Originally Posted by robert111

If I understand you correctly, with one "b" in the array, you want the returned answer to be 2, and for 2 "b"'s, 4.

So just multiply by 2

ermm.. what I meant is that I would like the MATCH function to trace my second matched token which is "b" at the 4th position of the array instead of the first matched token that is at the 2nd position.