I'm using the following formula to reference a column that meets specific criteria but keep getting an error instead of the expected value (which should be the number "2", if you look at the test worksheet attached):

=MATCH("NO",ADDRESS(ROW(A2),SUM(1,B2))&":"&ADDRESS(ROW(A2),SUM(10,B2)),0)

The problem as far as I can tell when evaluating the formula step-by-step is that the lookup_array that the formula generates is enclosed within quotation marks, which results in the error. Is there another function that I need to nest in there or some other way to return the lookup_array as cell references rather than text? Example workbook is attached. Appreciate the help!Test Worksheet 2.xls