Search table with multiple criteria and return row

I have been working on a variation of this for a long time and I cannot get it to work.

It is better to just post the example and go from there.

I am trying to depending on the textbox selection get the proper ROW from DEALLIST to show up.

If I've understood... I would do the following (based on what you have presently)

I1:J7 enter field names where I is field <> "" and J is field = "", eg:

Sold	Delivered
Delivered	Approved
Approved	Booked
Booked	Finalized
Finalized	Funded
Funded	Titled
Funded	TradePO

Then ascertain column positions within your table

K1: =MATCH(I1,'Deals 1.0'!$1:$1,0)
applied across matrix K1:L7

Clear the present formulae in H1:H7, given you only need output for one given selection at any given time there is really no need to conduct 7 SUMPRODUCTs - 1 will suffice and this can be done in A4 directly such that:

A4:
=SUMPRODUCT((INDEX(DEALLIST,0,INDEX($K$1:$K$7,$A$2))<>"")*(INDEX(DEALLIST,0,INDEX($L$1:$L$7,$A$2))=""))

For returning table row positions for given selection and again (as above) utilising the table you put into place in I1:J7

A9:
=IF(ROWS($A$9:A9)<=$A$4,SMALL(IF((INDEX(DEALLIST,0,INDEX($K$1:$K$7,$A$2))<>"")*(INDEX(DEALLIST,0,INDEX($L$1:$L$7,$A$2))=""),ROW(DEALLIST[Sold])-ROW(INDEX(DEALLIST,1,1))+1),ROWS($A$9:A9)),"")
confirmed with CTRL + SHIFT + ENTER
copied down as required

As you alter your selection in the Form Control so the row list should update accordingly.