Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Find out how Microsoft uses activity history data to provide personalized cross-device experiences and to help improve its products and services.

The DATE function returns the sequential serial number that represents a particular date.. Syntax: DATE(year,month,day) The DATE function syntax has the following arguments: Year Required.The value of the year argument can include one to four digits. Excel interprets the year argument according to the date system your computer is using. By default, Microsoft Excel for Windows uses the 1900 ...

If you cannot open your Outlook data file or suspect that the file is damaged, use the Inbox Repair tool (scanpst.exe) to repair errors in the file.

Download Office language interface packs (LIP) By pressing submit, your feedback will be used to improve Microsoft products and services.

了解如何使用产品密钥或数字许可证激活 Windows、检查激活状态，以及链接Microsoft 帐户。

Learn how to use Snipping Tool to capture a screenshot, or snip, of any object on your screen, and then annotate, save, or share the image.

Discover how to earn Microsoft Rewards points through various activities and redeem them for exciting rewards.

Learn how to upgrade your existing device to Windows 10 or buy a new PC. Get answers to common questions about upgrading to Windows 10.

Learn how to unlock your Microsoft account and resolve 'account has been locked' error message.