Forum Discussion
Help finding a formula in Excel
In English:
=IFERROR(INDEX(Foglio2!$A$2:$A$34890, MATCH(1, (Foglio2!$L$2:$L$34890=C2)*(Foglio2!$F$2:$F$34890=F2), 0)), "")
In Italian:
=SE.ERRORE(INDICE(Foglio2!$A$2:$A$34890; CONFRONTA(1; (Foglio2!$L$2:$L$34890=C2)*(Foglio2!$F$2:$F$34890=F2); 0)); "")
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
you are right! unfortunately at the moment I don't have my laptop with me and I don't have access to the file. could you try to write the formula according to your knowledge and see what result you get?
In English:
=IFERROR(INDEX(Foglio2!$A$2:$A$34890, MATCH(1, (Foglio2!$L$2:$L$34890=C2)*(Foglio2!$F$2:$F$34890=F2), 0)), "")
In Italian:
=SE.ERRORE(INDICE(Foglio2!$A$2:$A$34890; CONFRONTA(1; (Foglio2!$L$2:$L$34890=C2)*(Foglio2!$F$2:$F$34890=F2); 0)); "")
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.