Trying to identify largest value of a result set in an array

I have an array formula as follows:

{=INDEX(K6:K26, MATCH(1, (G6:G26=G3)*(H6:H26>=H3)*(I3>=LARGE(I6:I26,COUNTIF(I6:I26,"<"&I3)+1))*(J6:J26>=J3), 0))}

The parts referencing column "G" and "H" work fine. I am trying to locate the largest result in column "I" that has already returned a True result for columns "G" and "H". This isn't working because the Large and Countif only return a single True rather than an Array of True and False.

I also tried without the Large and CountIf; however that returns the first result in the column "I" that also had returned True in "G" and "H". I need the largest result in column "I".

Without the Large and CountIf:

{=INDEX(K6:K26, MATCH(1, (G6:G26=G3)*(H6:H26>=H3)*(I6:I26<I3)*(J6:J26>=J3), 0))}

I attached the sample spreadsheet.

Any suggestions?

The attached spreadsheet has that information located in it.

The values I provided as input for the search is in row 3. There are 6 values that need to be evaluated. The first 3, I combined into one to make the Match easier. The next 3 are independently checked; however provide subsequent conditions for the evaluation of each. I modified the data set so that you can see the row that is being returned (not correct) with a "N" value and the row with the correct result contains a "Y" value.

Wouldn't =INDEX(K6:K26, MATCH(1, (G6:G26=G3)*(H6:H26>=H3)*(I3:I26>=LARGE(I6:I26,COUNTIF(I6:I26,"<"&I3)))*(J6:J26>=J3), 0)) include both the input value and my lookup list?

That sort of works, except now I need to be able to grab the lower result in column J. In the data set, if my value is <= to the first found LTV, that is the one I want to use.

Also, I realized that the formula needs to reflect

=LOOKUP(2,1/((G6:G26=G3)*(H6:H26>=H3)*(J6:J26>=J3)*(I6:I26<=I3)),K6:K26)

I added another document that is the source for the table I am building for the lookup.

The objective of this is to be able to take the results of a variety of information which for now I am manually inputting into the spreadsheet I attached earlier and determine the resulting value in column K that meets the criteria in the other columns based on this attached documents rules.

Let me know if this is enough information.

It's not really that complicated. All of that can be identified in the columns I set up. I stopped adding the data to the table until I had a formula that worked for the sample set I started with. No point building the full lookup list if I don't have a formula that works. I only added a small portion from the beginning of that page.

Definitely. That's why I added the source document and included the spreadsheet.

I should have been more specific and added the source document in the first place. I'm new to this forum and just getting the hang of it. Any suggestions to be a better participant are definitely welcome.

Not sure how to explain it differently unless I just retype the PDF document.

Any suggestions on what would make sense to include?

It doesn't work when I change the input value. If I change the LTV to 76% it should return a value of 2 located on row 17 and I am getting 0.