Mhartdegen
New Member
- Joined
- May 24, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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.
{=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.