VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
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
Using email in Outlook on the web - Microsoft Support
Get help with signing in, changing passwords, creating and sending mail, deleting mail, creating folders, and more in Outlook on the web.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016
Troubleshooting verification code issues - Microsoft Support
That verification method isn’t working right now: Sometimes the block may be tied to the verification method you are using.Try using another verification method connected to your account. For example, if you are using SMS to verify yourself and are hitting a block, try using an alternate email that is connected to the account to receive your authorization code.
Applies To: Microsoft account dashboard
Repair apps and programs in Windows - Microsoft Support
Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.
Download and install Microsoft 365 Access Runtime
The Access 365 Runtime is like previous runtimes in that all design-related UI is either removed or disabled. The Access 365 Runtime includes the Access Database Engine which contains a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel (*.xls, *.xlsx, and *.xlsb ...
Applies To: Access for Microsoft 365, Access 2021, Office 2021, Access 2019, Office 2019
Help in WordPad - Microsoft Support
Get answers to common questions about WordPad. Here are a few tips to help you use WordPad: To open and save files, select File, then select New to create a new document, Open to work with an existing document, or Save to save your document.(If your document doesn't have a name, WordPad will ask you to provide one.)
Pin, remove, and customize in Quick access - Microsoft Support
By default, File Explorer opens to Quick Access. You can set a folder to show up in Quick access so it'll be easy to find. Just right-click (or long-press) it and select Pin to Quick access. Unpin it when you don’t need it there anymore by right-clicking (or long-pressing) it and selecting Unpin from Quick access.. If you want to see only your pinned folders, you can turn off recent files or ...
Featured Visio templates and diagrams - Microsoft Support
Visio is a diagraming tool that makes it easy and intuitive to create flowcharts, diagrams, org charts, floor plans, engineering designs, and more by using modern templates with the familiar Office experience. On this page, you can access some of the top templates and sample diagrams available in Visio, or request ones that you want. To see the hundreds of templates and sample diagrams ...
Applies To: Visio Plan 2, Visio in Microsoft 365, Visio Plan 1, Visio Professional 2021, Visio Professional 2019, Visio Professional 2016
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.
在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 IF 函数成对使用。
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 Web App, Excel for Windows Phone 10