Lookups

VLOOKUP, XLOOKUP, INDEX MATCH and FILTER in Google Sheets: several conditions, several columns, the last match and the mistakes that return a wrong value, all tested.