The XLOOKUP function in Google Sheets searches for a value in a range and returns a corresponding value from another range. Unlike VLOOKUP, it allows searches in any direction (left or right) and offers more flexibility, making it perfect for modern data lookups.
