Hello all,
I tried using a match function with multiple criteria but could not get it to work, even though when I evaluate the formula I see that Excel found a TRUE value. All I get are #N/A. I am using 0 for an exact search. When I used one criteria in an array I also got an error
{Match(1, (A:A=A2), 0)} but got it to find a match when I multiplied the array by 1 {Match(1, (A:A=A2)*1, 0)}. Why? However, that trick did not work for more criteria. I only filled in the first row but all rows return #N/A. It seems like a simple error that I cannot figure out.
Any help would be appreciated.
Bookmarks