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.

Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.

Microsoft 365 is our cloud-powered productivity platform. With a subscription to Microsoft 365, you can get: The latest productivity apps, such as Microsoft Teams, Word, Excel, PowerPoint, Outlook, OneDrive, and so much more.

Visio is a diagraming tool that makes it easy and intuitive to create flowcharts, diagrams, org charts, floor plans, engineering designs, and more by using modern templates with the familiar Office experience. On this page, you can access some of the top templates and sample diagrams available in Visio, or request ones that you want. To see the hundreds of templates and sample diagrams ...

Optional: To customize the ScreenTip that appears when you rest the pointer over the hyperlink, click ScreenTip in the top-right corner of the Insert Hyperlink dialog box and enter the text you want. You can also create a hyperlink to a blank email message by simply typing the address in the document. For example, type someone@example.com, and Microsoft 365 creates the hyperlink for you ...

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.

You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

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 ...

Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:

Use rules to automatically perform specific actions on email that arrives in your inbox. For example, you can create rules that will change the importance level of messages as they come in, automatically move them to other folders, or delete them based on certain criteria.