help with if match index giving false

Cross-posted at https://www.mrexcel.com/board/thread...index.1220651/

can someone help me understand why this is returning false:

if use type = use type, if (cell = yes, then if year 1 is less than or equal to year 6 then index(refinance mortgage balance,match year), if cell = yes, if year 6 is > year 1 then index(mortgage balance, match year), if cell = no, then index(original original mortgage balance, match year)

=IF($C$22=$ER$21,IF($S$4="yes",IF($S$7<=ES20,INDEX('Assumption Amortization Refinan'!$K:$K,MATCH(ES20,'Assumption Amortization Refinan'!$G:$G,0)),IF($C$22=$ER$21,IF($S$4="yes",IF($S$7>ES20,INDEX('Assumption 1 Amortization'!$J:$J,MATCH(ES20,'Assumption 1 Amortization'!$F:$F,0))))))),IF($S$4="no",INDEX('Assumption 1 Amortization'!$J:$J,MATCH(ES20,'Assumption 1 Amortization'!$F:$F,0))))

i am trying to accomplish that if it says no then it should pick up the numbers on the assumption 1 amortization

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I have added the link for you because it's your first post.

Please see yellow banner at the top of the page and attach your file with sample data. It will be nearly impossible to answer this without seeing what data is actually in your file and trying to unwind what this formula is trying to do.