Returning a column within a Named Range or Structured Table array of a given value

[Calgary_Neil]

Hello, thanks for looking

I was hopping that my last post ( Structured Table Names for current row ) would have given me workable answer to this problem.
I need to find in array (7*20+ x 25 rows) if a number or greater is a selected in a row. This done by checking the 1stcolumn in a set of 7 for that value, for that row i.e.:
N( MOD( COLUMN( $B82:IV82) +4, 7) =0) and N( $B82:$IV82 >= 4)

Now the 7th cell check does not need to a “THE” row, just an array of the same length, keyed properly. When I replace the check value array with Index(Match)) it #Ref out. So that’s an array problem(??).

So what I would like is the cell reference(?)** of the first value in the proper column & row meeting the check Value & ID given. I would prefer that it uses named ranges or structured tables as I’m trying to make this small-tight-flexible-understandable. {Ha Ha, dream on}.

Foggy in the North, Neil
Excel 365 32 bit

**I can work this out, but need the Subset number ultimately. i.e. QUOTIENT( COLUMN()+adjustment, 7)

 

[Calgary_Neil]

What a day makes. First problem solved, INDEX needs a column number of 0 to return an array. DUH

 

[Calgary_Neil]

End solution:
=QUOTIENT( MATCH( 1,
N( MOD( COLUMN( INDEX( Prod_Tech,1,0)) +4, 7) =0) *
N( INDEX(Prod_Tech, MATCH( AW22, Prod_TechID, 0), 0)>=AX22 ),
0) +5, 7)
where
Prod_Tech is the array,
Prod_TechID is the first column of the array, (the ID column)
AW22 is the ID of which row in the array to work on,
AX22 is the first value to find on that array row in a keyed column.

Any better ways out there?
Neil, in the snowy north