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.
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.