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.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Scan a document or picture - Microsoft Support
Use your scanner and download an app from Microsoft Store to scan a document or picture to your PC.
Getting started with the new Outlook for Windows
Important: Most accounts are supported in new Outlook.This includes Microsoft accounts such as an Outlook.com or Hotmail.com account, work or school accounts assigned to you by your organization’s admin, third-party accounts such as Gmail, Yahoo!, iCloud, and other third-party accounts connecting through IMAP.
Applies To: New Outlook for Windows
File sharing over a network in Windows - Microsoft Support
Learn about file sharing over a network in Windows. Note: This article focuses on how to share files or folders over a Local Area Network (or LAN), such as connected computers within your home or workplace.If you are trying to find out how to share a file over the Internet, for example with a friend or family member, OneDrive provides easy ways to accomplish this.
Getting the most out of Microsoft Rewards - Microsoft Support
Here are some best practices for earning Microsoft Rewards points so you can redeem them for gift cards, games, sweepstakes, nonprofit donations, and more.
Connect to a Wi-Fi network in Windows - Microsoft Support
Whether you're at home, work, or out and about, chances are you'll find a Wi-Fi network that you can connect to for internet access. Select the Network, Sound, or Battery icons ( ) on the far right side of the taskbar to open quick settings. The Disconnected icon appears when you’re not connected.
Windows 11, version 23H2 update history - Microsoft Support
Windows 11, version 21H2; September 10, 2024—KB5043067 (OS Build 22000.3197) August 13, 2024—KB5041592 (OS Build 22000.3147) July 9, 2024—KB5040431 (OS Build 22000.3079)
POP, IMAP, and SMTP settings for Outlook.com - Microsoft Support
If you're trying to add your Outlook.com account to Outlook or another mail app, you might need the POP, IMAP, or SMTP settings. You can find them below or by viewing them in your Outlook.com settings.. Outlook and Outlook.com may be able to detect your account's mailbox settings automatically, but for other non-Microsoft accounts, you may need to contact your email provider for their settings.
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, Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook on the web, Outlook.com, Outlook Web App for Office 365 operated by 21Vianet, Outlook Web App Light, New Outlook for Windows, Outlook for Android, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
How to redeem Microsoft Rewards points - Microsoft Support
Note: Offers vary by country.Be sure to redeem your rewards points in the same region you signed up in. Do not use a VPN while trying to redeem points. When redeeming points, use a mobile or landline phone number for authentication and not a VoIP phone number.
Applies To: Microsoft account dashboard
Welcome to Copilot in Word - Microsoft Support
Whether you're creating a new document or working on an existing one, Copilot can help you move forward. In a new, blank document or upon creating new line in an existing document, the Draft with Copilot experience appears.. The description you provide can be a simple sentence or a more complex request with outlines, notes, or referenced files that you want Copilot to use.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word for iPad