Skipping a cell if False from another sheet

Hello,

I'm trying to format a report from an exported SharePoint list. I'm trying to compare column B in the data sheet and if TRUE then display the value from column G in my report sheet (Column A). IF the result is false I want the formula to skip that row and move to the next. I've copied my example below along with the code I've been trying to use but without any luck.


clip_image001.jpg

clip_image001.jpg

=IFERROR(INDEX(Table_owssvr_1[Grouping (Reporting Only)],SMALL(IF(Table_owssvr_1[Grouping (Reporting Only)]="Flexcube/Acct Svcs/BF/NUSPF",ROW(Table_owssvr_1[FSD Name])-ROW('owssvr(1)'!B2)+1),ROWS(Table_owssvr_1[Grouping (Reporting Only)]))),"")

Thanks
John

I've also tried the following code, but I need this formula to skip the rows that are false and not display those cells on the report.

=IF("Flexcube/Acct Svcs/BF/NUSPF"=INDEX('owssvr(1)'!B:B,MATCH("Flexcube/Acct Svcs/BF/NUSPF",'owssvr(1)'!B:B,0)+MOD((ROW()-4),90)),INDEX('owssvr(1)'!$G$2:$G$88,MATCH("Flexcube/Acct Svcs/BF/NUSPF",'owssvr(1)'!$B$2:$B$88,0)+MOD((ROW()-4),90)),"")

untitled.JPG

Thanks
John