Find position of text in dynamic range google spreadsheet -


i have range formula

address( 302 ; row() ; 4 ; true)&":"&address( 401 ; row() ; 4 ; true) 

starting @ row 1 output a302:a401 want find position of text in range.

match("*"&a1&"*";a302:a401;0) 

i don't know how make work.

so managed find answer. using indirect around address ranges works. have copy paste in different fields , range updates correctly.

=match("*"&a1&"*";indirect(address(302 ; row()-2 ; 4 ; true)&":"&address( 401 ; row()-2 ; 4 ; true));0) 

Comments