Array formula using greater than but also less than

Hi all,

I have the following array formula that return the first 10 records (where Variables!$F$3 = 10)

Formula:

Please Login or Register  to view this content.

Then I want to return in another column the next 10 i.e. between Variables!$F$3 and Variables!$F$3*2

I have tried this following formula:

Formula:

Please Login or Register  to view this content.

But putting in the AND formula, the formula fails completely. I can't figure out how to return the next 10.

Can anyone help?

Many thanks in advance,

Alex

Try
=IFERROR(INDEX($G$2:$G$100,SMALL(IF(($H$2:$H$100>Variables!$F$3)*($H$2:$H$100<=(Variables!$F$3*2)),ROW($G$2:$G$100)),ROW(1:1))-1,1),"")

Entered with CSE
If that doesn't work, please supply a workbook

OMG, you're a genius! Thank you so much!

You're welcome & thanks for the feedback