IFERROR, INDEX, and MATCH Issue

[Mhartdegen]

I have a sheet of data that I'm attempting to pull from using the formula below.
{=IFERROR(INDEX(Verify!$A$2:$A$500,SMALL(IF(F$2=Verify!$J$2:$J$500,ROW(Verify!$J$2:$J$500)- MIN(ROW(Verify!$J$2:$J$500)),""), ROW())),"")}
I have attached a photo of my sheet. I am attempting to return all of the data from b2:b36 that match to the text in F2:Q2 to A2:A36 in an array below.

 

[Fluff]

Hi & welcome to MrExcel.
Your formula & description do not match, but based on the description try

=FILTER(B2:B100,ISNUMBER(MATCH(A2:A100,F2:Q2,0)))

 

[Mhartdegen]

Hi & welcome to MrExcel.
Your formula & description do not match, but based on the description try

=FILTER(B2:B100,ISNUMBER(MATCH(A2:A100,F2:Q2,0)))

Maybe I can explain what I'm trying to accomplish in a better way. I am attempting to match F2:Q2 (62DACH:62EDCA) to A2:A36 and for each match to F2:Q2 return the data in B2:B36 below the F2:Q2 search data. For example, below H2 (62GAJE) the return would be B2 (2779384) and M2 (62DAKE) would return B18 (2780104), and any other matches within data.

 

[Fluff]

Did you try the formula I suggested?

 

[Mhartdegen]

Did you try the formula I suggested?

I did. It returns an error stating "That function isn't valid".

 

[Fluff]

Are you using 365 as per your profile?