Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
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.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Pin apps and folders to the desktop or taskbar - Microsoft Support
To pin apps to the taskbar. Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar. If the app is already open on the desktop, press and hold (or right click) the app's taskbar icon, and then select Pin to taskbar.
Fix Bluetooth problems in Windows - Microsoft Support
If you run into problems trying to connect to a Bluetooth device, here are some troubleshooting steps to try. Note: For general info about how to connect a Bluetooth device to your PC, see Pair a Bluetooth device in Windows.
Send and receive text messages from your PC - Microsoft Support
Sending a message. If you haven't already set up messages, do the following: On your PC, in the Phone Link, select Messages. To start a new conversation, select New message. Enter the name or phone number of a contact. Select the person you want to send a message to.
Download and install apps - Microsoft Support
Download and install or reinstall Microsoft 365 or Office 2021 on a PC or Mac. Set up Office apps and email on a mobile device. Small business help and learning. Learn how to download and install apps you need from your Microsoft 365 business subscription.
Fix your Outlook email connection by repairing your profile
Having trouble connecting to your email from Outlook on your desktop? Follow these steps to let Outlook diagnose and fix errors in your Outlook mail profile that might be causing the issue.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
Request a refund for digital games | Xbox Support
Find out how to submit a request for a refund for a purchase of digital Xbox content.
How to use the PC Health Check app - Microsoft Support
PC Health Check app brings you up to date info on your Windows device health, helping you take action to improve your device performance and troubleshoot performance problems. It is periodically updated based on customer feedback to help you make the most of your Windows PC. How to open PC Health Check. In Windows, use Search on the taskbar to ...
Link your social network accounts to Xbox | Xbox Support
You can link your social media account in one of two ways: Use the Xbox mobile app to scan the QR code. Select the Link option which will launch the Microsoft Edge app on Xbox. You can choose to link your Discord, Reddit, Steam, Twitch, or other social media account.
Use the On-Screen Keyboard (OSK) to type - Microsoft Support
The most common type is a physical, external keyboard that plugs into your PC. But Windows has a built-in Accessibility tool called the On-Screen Keyboard (OSK) that can be used instead of a physical keyboard. You don’t need a touchscreen to use the OSK.