Hello everyone, can someone tell me how to set this formulas: =MAX(INDEX((A3=Sheet1!$F$2:$F$3000)*Sheet1!$A$2:$A$3000;)) and =VLOOKUP(B3;Sheet1!$A$3:$M$3000;13;FALSE) that works in Excel to work in Libreoffice? Thank you all.
Should you try to set the formula in Calc by clicking the shhets you want to reference. You should at least use “.” after the sheet name, e.g Sheet1.A1 rather than Sheet!A1.
2 Likes