The XLOOKUP function in Google Sheets allows you to search in any direction, return multiple results, and gracefully handle missing values.

INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally