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.
I tried to copy your formula (the names of the formulas are in Italian but they are those indicated by you), however the error appears on this part:
If you use comma as decimal separator (for example 3,14), you should use semicolon ; instead of comma , in the formula.
ok
; make the formula work but the result is always ""
I can't understand where I'm wrong 😞
Could you attach a sample workbook with the formula, or make it available through for example OneDrive?
I am attaching an example of a file, once I find the right formula I will use it on the general one with the exact same layout.
in practice: if C & F of Sheet1 are present in F & L of Sheet2, in P of Sheet1 I must have A of Sheet2.