Extract formula text

[blachloch]

I have a variable range of data of roughly 2000 rows some of which have TRUE in a column and the rest show FALSE. I want to condense the first range and only present the rows with TRUE in the specific column - the other caveat is I would much prefer to do this using formulas instead of VBA.

One thought I had was to use a VLOOKUP to find the first instance of TRUE for the first row of data - success.
The next step is for row 2 to find the next instance of TRUE. My thought is to use the same VLOOKUP formula but bump the starting row up to where the first instance was found +1.

Example:
=VLOOKUP(TRUE,'Tab name'!A1:B2000,2,FALSE) where Column B contains the row number so that if the first TRUE row is row 96 it will return 96.

For the second occurance, I need to access both the formula text (=VLOOKUP(TRUE,'Tab name'!A1:B2000,2,FALSE)) and the formula result (96) to build the next formula of:

=VLOOKUP(TRUE,'Tab name'!A97:B2000,2,FALSE)

How can I pull both the cell value of "96" AND the formula text of "=VLOOKUP(TRUE,'Tab name'!A1:B2000,2,FALSE)" to build each successive formula?

Thanks,
DC

[NBVC]

One way would be to first add a helper column to the Tab Name tab.

So in B2:

=IF(A2=TRUE,COUNT(B$2:B2)+1,"") and copy it down

Now use formula in summary tab.

=IFERROR(INDEX('Tab name'!A:A,MATCH(ROWS($A$2:$A2),'Tab name'!$B:$B,0)),"")

copied down.