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
Troubleshoot in Microsoft Teams - Microsoft Support
Having trouble using Microsoft Teams? Help solve your peskiest issues and frequently asked questions (FAQs) with this troubleshooting guide.
Applies To: Microsoft Teams
Surface Pro (5th Gen) specs and features - Microsoft Support
Surface Pro (5th Gen) and Windows 10. Surface Pro (5th Gen) comes with Windows 10 Pro edition. If you're not sure which Surface model you're using, see Which Surface model do I have?. Diagrams of Surface Pro (5th Gen)
Send an email message based on a template - Microsoft Support
The default templates folder is opened. The folder location (in Windows 7 and later operating systems) is c:\users\username\appdata\roaming\microsoft\templates.If your template is saved in a different folder, click Browse, and then select the template.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Connect Surface to a TV, monitor, or projector - Microsoft Support
If your screen only has a Mini DisplayPort, you can set up the following connections—connect a USB-C to HDMI adapter to an HDMI cable then to an HDMI to Mini DisplayPort and then to your external screen. Keep in mind that the more adapters used, the more degraded the signal may get.
Add and sync shared folders to OneDrive for home
When someone shares a folder with you, it appears in the Shared section of your OneDrive.com.If you have Edit permissions to those shared folders, you can add them to the My files section of your OneDrive to make them easier to access and work with. If you want to view and access shared folders on your PC or Mac, install the OneDrive app and sync your folders to your device.
Applies To: Office for business, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Use Game Bar to play and chat with friends | Xbox Support
To create a post: Select the Find players tab, choose a game, and then select Create a post.; Add tags and a description (this makes it easier to connect with gamers that play like you), then adjust the details, such as the number of players needed.
Add and remove group members in Outlook - Microsoft Support
Add guests to a group. When you add guests, also known as external users, to a group, you're granting them access to all information within the group.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, New Outlook for Windows, Outlook for iOS
Sign out of Office - Microsoft Support
In any Office app, go to File > Account (or Office Account in Outlook) > Sign out.
Applies To: Microsoft 365 for home
Change notification and quick settings in Windows
In Windows 10, action center is where you'll find your app notifications and quick actions—which give you quick access to commonly used settings and apps.