How to correct a #N/A error in the VLOOKUP function
Tip: Also, refer to the Quick Reference Card: VLOOKUP troubleshooting tips which presents the common reasons for #NA issues in a convenient PDF file. You can share the PDF with others or print for your own reference.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for Windows Phone 10
Add an exclusion to Windows Security - Microsoft Support
If you trust a file, file type, folder, or a process that Windows Security has detected as malicious, you can stop Windows Security from alerting you or blocking the program by adding the file to the exclusions list.
Windows Update Troubleshooter - Microsoft Support
Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.
KB5025885: How to manage the Windows Boot Manager revocations for ...
Summary. This article describes the protection against the publicly disclosed Secure Boot security feature bypass that uses the BlackLotus UEFI bootkit tracked by CVE-2023-24932, how to enable the mitigations, and guidance on bootable media.A bootkit is a malicious program that is designed to load as early as possible in a devices boot sequence to control the operating system start.
How to get and use app passwords - Microsoft Support
After you turn on two-step verification or set up the Authenticator app, you may run into issues if you use older devices (like Xbox 360 or a mail-sending security camera) that don't support two-step verification. For those devices, you can sign in with an app password instead. An app password is a long, randomly generated password that you provide only once instead of your regular password ...
Cooking up a great prompt: Getting the most from Copilot
Prompts are how you ask Copilot for Microsoft 365 to do something for you — like creating, summarizing, editing, or transforming. Think about prompting like having a conversation, using plain but clear language and providing context like you would with an assistant.
Find safe mode and other startup settings in Windows 10
After your PC restarts to the Choose an option screen, select Troubleshoot > Advanced options > Startup Settings > Restart.You may be asked to enter your BitLocker recovery key.
Fix problems that block programs from being installed or removed
Note: Use these steps for Windows programs.If you're having problems with an app you got from Microsoft Store, go to Fix problems with apps from Microsoft Store.
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Work together on PowerPoint presentations - Microsoft Support
Share your file with others. To invite other people to access your PowerPoint file and collaborate, take these steps: With the presentation open, select the Share button in the top right corner of the ribbon. If you have not yet stored your presentation to OneDrive or SharePoint in Microsoft 365, a message will direct you to do so.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016, PowerPoint for iPad, PowerPoint for iPhone, PowerPoint for Android tablets, PowerPoint for Android phones, PowerPoint Mobile