excel - Find a range by to criteria -

excel - Find a range by to criteria -

it have difficulties combine right excel functions extract right info sheets.

the info sheet structured like:

|abdefghijklmn -+--------------------- 1| opqrst 2|7 3|7 4|8 x 5|8 x 6|9

in table have criteria used search, e.g. "r" , "8", range (f4:f5, marked "x", "x" not actual content). goal check if resulting range contains non-empty cells.

any help?

i tried approach using address , match, not seem work...

if info sorted ascending in column a, formula work:

=counta(index($1:$1048576,match(l2,$a:$a,0),match(l1,1:1,0)):index($1:$1048576,match(l2,$a:$a,1),match(l1,1:1,0)))

l1 holds column label text, l2 holds row label number. applied in cell l4 , copied right other value pairs.

excel vba