False value, then skip to next line, etc.

I am trying to create a formula that will go to a column on another tab, determine if it matches a value, and if it does not match that value, instead of leaving the cell blank I would like it to skip to the next line down and determine if that cell has the value. I am not sure how to go about this, but I have attached an example workbook to make specific references.

In the example attached:

On the Measure Model tab, I would like for cell A2 (under Application Type) to enter the application type (A2 on the Data Dump tab) if the Status is 'Invoice Sent' from the Status column (B2 on the Data Dump tab). However, if the status is something other than Invoice Sent, instead of leaving cell A2 blank (on the Measure Model tab), I would like for it to skip to the next line on the Data Dump tab until it finds a line where Invoice Sent is the value in the Status column. Then skip to the next line until Invoice Sent is found again.

I am not sure if I am explaining this well, feel free to follow up with questions. I appreciate all of your help. Thank you.

I put in the results that would occur if I could get it to work with another explanation. I hope this helps!

put this in A2

=IFERROR(INDEX('Data Dump'!$A$2:$A$357,SMALL(IF('Data Dump'!$B$2:$B$357="Invoice Sent",ROW($A$2:$A$357)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

Enter with Ctrl+Shift+Enter (Array formula)

Copy down until you get blank cells

This will list all applications with status of "Invoice Sent"

Yes! This is perfect, thank you.