I have a value in a cell I want to use as the search argument against a 2D array of values (in no particular order). Then I want to know if the search value was within the 2D array.
Thanks
Mike
I have a value in a cell I want to use as the search argument against a 2D array of values (in no particular order). Then I want to know if the search value was within the 2D array.
Thanks
Mike
This works for any range of cells....
C1:F10 contains words, blanks, numbers, whatever
A1: (a word to find)
This formula returns TRUE if a match is found:
B1: =COUNTIF(C1:F10,A1)>0
Does that help?
Post back if you have more questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks