Xlookup formula usage on Google Sheets [Very Easy]

Description: XLOOKUP is an Excel function that helps you find a value in a range (from a table) and returns a corresponding value. It's an improved version of VLOOKUP and HLOOKUP, offering more flexibility and ease of use.

Example: Assume that this below is your table data.

Problem: You need to learn Alex Wong's score.

Formula: On another cell, input this formula

=XLOOKUP("Alex Wong"; B2:B5; C2:C5)

If you get the #AD? error in the cell in Microsoft Excel, the reason may be version differency. There might be a formatting issue or your Excel version might not support the XLOOKUP function. XLOOKUP was introduced in Excel 365 and Excel 2019. If you are using an older version of Microsoft Office, it might not recognize the function.

This is why I like to use Google Sheets online to keep the version always updated. Instead of using Microsoft Office, Google Docs and Google Sheets are my online solutions for office needs whenever you have an internet connection, or offline usage when you download Google's office apps to your mobile phone and tablet.

Feel free to use this description as a quick reference to understand the basics of XLOOKUP. If you have any specific questions or need further clarification, feel free to ask! ???? #ExcelTips #DataAnalysis #XLOOKUPFormula

Onur Yolal