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
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To:
Microsoft Teams
Keyboard shortcuts for Outlook - Microsoft Support
Top of Page. Contacts (People) keyboard shortcuts. The People view is your address book in Outlook where your personal contacts are stored and where you can open any address book that has been set up for your organization. The People, Mail, and Calendar views work together so you can easily send mail to and schedule appointments with your most important people.
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 on the web, Outlook.com, New Outlook for Windows, Outlook for iOS, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Manage app permissions for your camera in Windows
To use your camera with apps on Windows 11, you'll need to turn on some permissions in Camera settings. Then, you'll need to check your app permissions if you want to use your camera with apps.
Organize your ideas with Collections in Microsoft Edge
Collections in Microsoft Edge helps you keep track of your ideas on the web, whether you're shopping, planning a trip, collecting notes for research or lesson plans, or just want to pick up where you left off the last time you were browsing the internet.
Microsoft .NET Framework 4.7.2 offline installer for Windows
Issues that are fixed in this update. The following issues are fixed for .NET Framework 4.7.2. SQL Server (SQL) Fixes an issue in which the .NET Framework API SqlConnection.ConnectionString property is used to set a null or empty connection string. In this situation, a Null Reference Exception (NRE) occurs when you use the API together with .NET Framework 4.7.2.
Temporarily allow cookies and site data in Microsoft Edge
To help protect your privacy, the new Microsoft Edge sets tracking prevention to balanced by default. For increased protection, you can switch your tracking prevention to strict or block all third-party cookies.
Fix problems with the Start menu - Microsoft Support
Sign out of your account and then sign in to your new account. If everything is fixed, move your personal data and files to the new account. To move your personal files from your old account to your new account, try opening File Explorer, expanding This PC > OSDisk (C:), and looking in the Users folder, where you should see folders for both accounts.
Manage Microsoft 365 payment information and billing for your business
On the Invoices tab, choose the invoice that you want to view.If you don't see an invoice, use the date filter and select Past 3 months, Past 6 months, or Specify date range.
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.