Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
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. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Apply sensitivity labels to your files and email in Outlook
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies.
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Look up values in a list of data - Microsoft Support
Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned.
LOOKUP function - Microsoft Support
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price.
Get creative with 3D models - Microsoft Support
On Windows and macOS, Word, Excel, PowerPoint, and Outlook support inserting 3D models directly into your documents, workbooks or presentations to illustrate a point. You can rotate models 360 degrees or tilt up and down to show a specific feature of an object. Want to see live examples? Get templates.
Explode or expand a pie chart - Microsoft Support
To make parts of a pie chart stand out without changing the underlying data, you can pull out an individual slice, pull the whole pie apart, or enlarge or stack whole sections by using a pie or bar of pie chart. To emphasize an individual slice of a pie chart, you can move it back from the rest of the pie chart by doing the following:
How to correct a #SPILL! error - Microsoft Support
This error occurs when the spill range for a spilled array formula isn't blank. Select the formula to reveal a dashed border that indicates the intended spill range. By selecting the formula, an error checking alert will appear.
View previous versions of Office files - Microsoft Support
Restore a previous version of an item or file in SharePoint. Enable and configure versioning for a list or library. Use Version History to view previous versions of files stored in OneDrive or …
Use the Field List to arrange fields in a PivotTable
After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields. If you want to sort or filter the columns of data shown in the PivotTable, see Sort data in a PivotTable and Filter data in a PivotTable.
How to find and enable missing Copilot button in Microsoft 365 …
There are two settings here that can cause Copilot to not appear in your Microsoft 365 apps. First confirm that Experiences that analyze your content is turned on. Then scroll down and make sure that All connected experiences is turned on. In any Microsoft 365 app, select the app name (such as Word or PowerPoint) menu at the top of your screen.