Issue with logic formula.

[Arroyo]

Hi good morning,

I'm almost in the way way to "finish" this spreadsheet.
I have 69 codes and each one can have two conditions, this conditions are going to be subtracted from the original operation, the issue I have a large formula (16 rows), I can't place there.
I don't wish to place it in parts from a depending formula.
Already try if, if(or, if(and & lookup; before I knew they only accept (30 "concepts")
By the moment I'm still "working" on this; but honestly, my mind it's block.
Thanks.

 

[GlennUK]

Why can't you place the formula here?

 

[Arroyo]

Why can't you place the formula here?

Morning,
Thanks, GleenUK; already solved, I create a new table and use index and match, that solve the issue.

-INDEX($BZ$2:$CC$1513,MATCH(B23,BX2:$BX$1513,0),MATCH($BJ$3,$BZ$1:$CC$1,0))