Best Way to Search a 2D Array

[mchac]

I need to search a 'column' in a 2D array to see if I can find a match to user input value. I'd prefer not to loop

I've found this: http://www.mrexcel.com/forum/excel-...basic-applications-function-search-array.html and specifically Rick's solution.

And I've found this: http://www.jpsoftwaretech.com/finding-values-in-an-array-without-looping/.

Both seem to be suitable only for 1D arrays. Is that correct?

Also, what does Chr$(1) mean (from the first link)?

Thanks for your help.

 

[mchac]

Thanks Mike. Without the $ does it still always return a string?
No it's not in a worksheet. The array takes some parameters in a sheet then creates an array.


Thanks Blade Hunter.

 

[mikerickson]

Blade Hunter,
In my code, myArray is a two dimensional array, each element of which is a string.

In your code, myArray is a 1-dimensional array, each element of which is an array.

Where my syntax would be myArray(a, b) , your syntax would be myArray(a)(b)

Without the $ does it still always return a string?

Given a Ascii code number, Chr returns the string represented by it. It will always be a string. (Up to Excel's automatic type conversion routines.)

 

[mchac]

Thanks Mike. One follow up to make sure I'm clear on the syntax. Given the current excel conversion routines, is the $ redundant or does it accomplish something?

 

[mikerickson]

It is redundant.