VLOOKUP with error-checking in LibreOffice
I’ve used this before but it’s been ages and I always forget the syntax:
LibreOffice requires a dot to separate sheet names from cell references. I believe Excel and Google Sheets uses an exclamation point.
IFNA tells LibreOffice to use the lookup if found, otherwise use