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.

This article is for Outlook.com. If you're using Outlook for Windows, see Fixes or workarounds for recent issues in Outlook for Windows.. If you're having problems accessing Outlook.com, you can see the status of Microsoft Office Online Services at the Service Health portal.. If you're having problems sending or receiving email, read how to Fix Outlook.com email sync issues.

Create a drop-down list. You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. Windows macOS Web. In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you’ll have your list items in an Excel table.

The Microsoft Support and Recovery Assistant works by running tests to figure out what's wrong and offers the best solution for the identified problem. It can currently fix Office, Microsoft 365, or Outlook problems. If the Support and Recovery Assistant can't fix a problem for you, it will suggest next steps and help you get in touch with ...

Reset the Microsoft Store cache: Press the Windows Logo Key + R to open the Run dialog box, type wsreset.exe , and then select OK. Note: A blank Command Prompt window will open, and after about ten seconds the window will close and Microsoft Store will open automatically. Make sure Windows has the latest update. Check for Windows Updates.

To do this: Select Start > Settings > Time & language > Language & region. Open Language settings. Go to Preferred languages, select Add a language. In Choose a language to install, enter and select the name of the language that you want to install, then select Next.

Manage your Xbox subscription. Game Pass Ultimate or a supported free to play game is required for cloud gaming.

In the Run dialog box, type: Outlook.exe /profiles and then press Enter. While Outlook is running, select File > Account Settings > Change Profile. Outlook will restart. On the Profile picker dialog box, select Options. You can proceed to open the other profile and then use Account Manager.

Where can I find my BitLocker recovery key? BitLocker likely ensured that a recovery key was safely backed up prior to activating protection. There are several places that your recovery key may be, depending on the choice that was made when activating BitLocker:

Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.