Finding value in Array

[Rasm]

I have an array of strings (the strings are not on any sheet - just in a dynamic array - the array is dimmed as say i.e. "Dim MyString(20,5) as string" - I would like the match to be exact - so If I search for "Test" - and I have a value "Test" & "Test123" - I would like to only get the Index for "Test" - Ideally I would like my index to be say 5,3 if Mystring(5,3)="Test".

 

[Rasm]

Shg - Just tried Mike's way - using the nested loop -

I think you may be right about match being too slow.

I will try your method now

Thanks - for the help guys.

 

[shg]

It's hugely slow. FindVal1 uses Match and FindVal2 uses nested loops.