Tuesday, October 28, 2025

LibreOffice: Use XLOOKUP instead of VLOOKUP

=IFERROR(XLOOKUP(C2,'file:///mnt/marks.ods'#$Sheet1.$C$2:$C$115,'file:///mnt/marks.ods'#$Sheet1.$AC$2:$AC$115,""),"")