Use the XLOOKUP function to find things in a table or 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.

Swipe in from the right edge of the screen, and then tap Search.Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search.Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator.If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

To find touchpad devices, select Human Interface Devices or Mice and other pointing devices, then right-click the device you'd like to update.

We would like to show you a description here but the site won’t allow us.

If you're trying to add your Outlook.com account to Outlook or another mail app, you might need the POP, IMAP, or SMTP settings. You can find them below or by viewing them in your Outlook.com settings.. Outlook and Outlook.com may be able to detect your account's mailbox settings automatically, but for other non-Microsoft accounts, you may need to contact your email provider for their settings.

In the Step 1: Select condition(s) list, select the check boxes for any options that you want, and then click Next.. If you do not select any check boxes, a confirmation dialog box appears. If you click Yes, the rule that you are creating is applied to all messages that you send.

Microsoft added OAuth support for Yahoo! accounts in the Windows 10 Creators update. To install the Creators Update now, go to the software download site, and select Update now.For more information about Windows updates, see Get the latest Windows update.. If you have a Japanese Yahoo! email account, you'll need to do the following:

Features with audio and video functionality.. Many features that come as part of Windows can be used to view or play video or audio content. Here are some examples: OneNote app (lets people record or play audio), Microsoft Edge web browser (lets people play audio and video content on the internet), the Photos app, the OneDrive app, and others.

Learn how to activate Office pre-installed on new Windows 10 PCs or with a new product key.