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.

Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.

Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.

Note: Exporting and importing a mailbox using a .pst file isn't supported in new Outlook at this time. To export a mailbox, you need to use the desktop version of Outlook (also known as classic Outlook) following the steps below.Classic Outlook is included with Microsoft 365 subscriptions that include desktop apps such as Microsoft 365 Personal or Family or Microsoft 365 Business Standard, and ...

Tips: If you don't see the OneDrive icon, OneDrive might not be running. On a PC, go to Start, type OneDrive in the search box, and then click OneDrive in the search results. You might need to click the Show hidden icons arrow next to the notification area to see the OneDrive icons. On a Mac, use Spotlight to search for OneDrive and open it.

If you see a Let's get started screen with options to try, buy, or activate Office, this means that Office is installed on your new PC as a 1-month trial of Microsoft 365 Family. You won't receive a product key from your PC manufacturer unless you paid for an Office product key card. Instead, you can start a trial of Microsoft 365 Family, or buy Office.

Under Message organization, choose either of the options depending on whether you want to show email grouped by conversation or as individual message.. If you select Show email grouped by conversation, under Arrange the reading pane, select either of the options: Newest on top, Newest on bottom, or Show each message separately.

If you continue to experience issues signing in with your original profile, disable Windows Defender services: Open the Services app by typing services in the search box on the task bar and selecting it from the list of results. Then, find the Windows Defender Advanced Threat Protection and Microsoft Defender Antivirus services, right-click each of them, select Properties , and change Startup ...

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.

By setting up MFA, you add an extra layer of security to your Microsoft 365 account sign-in. For example, you first enter your password and, when prompted, you also type a dynamically generated verification code provided by an authenticator app or sent to your phone.