LibreOffice Calc - IFNA function
When a lookup function returns an NA error, the IFNA function can prevent the error message and display a custom message or execute a function. With IFNA you can lookup a value which is located in multiple tables.
Spreadsheet files used in video available at:
http://panopia.com/libreoffice/