A formula extracts a number that meets a few conditions

If I've understood... and assuming XL2007 per profile:

J8: =IFERROR(LOOKUP(9.99E+307,MATCH(B$8:B$32,OFFSET(F$8:F$12,5*(ROWS(J$8:J8)-1),0),0),$A$8:$A$32),"")
copied across J8:L12

if you need to use ; delimiters then:

J8: =IFERROR(LOOKUP(9.99E+307;MATCH(B$8:B$32;OFFSET(F$8:F$12;5*(ROWS(J$8:J8)-1);0);0);$A$8:$A$32);"")
copied across J8:L12

thank you

the formula works good but i don't know how to modify the formula if i want the short range to be 6,7 or 8? i think if i replace 5* with 6* ok?

...i think if i replace 5* with 6* ok?

yes, that is correct

if this something you will change regularly you may find it easier to replace the number with a cell reference - e.g. $Z$1* where Z1 holds the number (5,6 etc).
(obviously change the cell reference from $Z$1 to wherever it makes sense to store the number)