INDEX MATCH to SQL JOIN

People write INDEX/MATCH to look left. SQL never needed to look left. Join the key, select the column.

SELECT t.email, c.customer_id
FROM Tickets t
LEFT JOIN Customers c ON c.email = t.email;

Approximate MATCH (last arg 1) is a band table and BETWEEN, same as range VLOOKUP.

Canonical translation

SELECT t.email, c.customer_id
FROM Tickets t
LEFT JOIN Customers c ON c.email = t.email;