Hi all,
I have tried to expand my formula to bring back the result I need and I'm not getting very far. This is my formula so far
IF(OR(AY09="4A",AY09="4B"),<wbr>INDEX('[Matrix.xlsx]ICS Accounts'!$C:$C,MATCH("TOTAL-<wbr>04.09-A",'[Matrix.xlsx]Accounts'!$E:$E,0),MATCH(LEFT(<wbr>AW09,10),'[Matrix.xlsx]Accounts'!$C:$C,0)),AW09)
This part of the formula
Can anyone see what's wrong with my formula?
I have tried to expand my formula to bring back the result I need and I'm not getting very far. This is my formula so far
IF(OR(AY09="4A",AY09="4B"),<wbr>INDEX('[Matrix.xlsx]ICS Accounts'!$C:$C,MATCH("TOTAL-<wbr>04.09-A",'[Matrix.xlsx]Accounts'!$E:$E,0),MATCH(LEFT(<wbr>AW09,10),'[Matrix.xlsx]Accounts'!$C:$C,0)),AW09)
This part of the formula
MATCH(LEFT(
<wbr style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">AW09,10),'[Matrix.xlsx]Accounts'!$C:$C,0))
I am trying to say search column C within the matrix and match the first 10 characters of column C which will then match cell AW09. With all this match criteria within my formula I should get the right result but it's not working.Can anyone see what's wrong with my formula?