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 have a message open in its own window instead of the Reading pane, the Backspace key will not archive the message. You have to close the message and view it in the Reading pane for the Backspace keyto archive the message. When the message is open in a new window, the only way to archive the message is by using the Archive button on the ribbon.

Important: You won't lose files or data by resetting OneDrive on your computer.Resetting OneDrive only disconnects all your sync connections (including personal and work or school).

sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...

You can right-click the contact group and select Delete from the menu or click the group, then select Delete from the Ribbon.. Contacts are not deleted, only the contact list.

Create a group for your project or team. Create a PLC group in Outlook (Office 365 Education) A Professional Learning Community (PLC) group is a type of Microsoft 365 Group that provides a shared space for educators to use for collaboration.

MSN provides you with three quick ways to navigate through MSN to easily find what you need: The Mega menu located at the top left side of the page, brings you every section in just one easy step.

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.

Access, download, or run the Surface app and the Surface Diagnostic Toolkit to help find and solve Surface problems.

Add an interactive checklist. Checklist is a feature that allows you to insert an interactive list in Word for Web. You can check and uncheck the checklist and keep track of the tasks that you are performing.