XLOOKUP

The function is natively exclusive to Microsoft 365 and Excel 2021 or later. Because it is not officially supported in Excel 2010 , users must rely on third-party add-ins or custom scripts to use it. Top Recommended "XLOOKUP" Add-ins for Excel 2010

If you prefer not to use add-ins for compatibility reasons (e.g., sharing the file with others who don't have the add-in), you must use these built-in alternatives:

Example 3: If Not Found Message

XLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])