VLOOKUP 第一个参数是要查找的值。 此参数可以是单元格引用，也可以是固定值，例如“smith”或 21,000。 第二个参数是单元格搜索范围 C2-:E7，VLOOKUP 在其中搜索要查找的值。 第三个参数是单元格范围内包含所查找值的列。 第四个参数可选。 输入 True 或 False。 如果输入 TRUE 或留空此参数，则函数将返回第一个参数中指定的值的近似匹配。 如果输入 FALSE，函数将匹配第一个参数提供的值。 换言之，可以自由选择是将第四个参数留空，或是输入 TRUE。 此示例演示函数的工作方式。 在单元格 B2（第一个参数）中输入值后，VLOOKUP 搜索单元格 C2-E7（第二个参数），并从范围中的第三列 E 列（第三个参数）返回最接近的近似匹配。

如何使用 Excel 中的自动筛选查找和处理单元格或表格区域中的一部分数据。.

Note: The steps to install the 2019, 2016, or 2013 versions of Office Professional Plus, Office Standard, or a stand-alone app such as Word or Project might be different if you got Microsoft 365 through one of the following: Microsoft Workplace Discount Program (formerly known as Home Use Program): If you bought Microsoft 365 for personal use through your company, see Install Office through ...

将上标或下标格式应用于文本. 选择要格式化为上标或下标的字符。. 在“ 开始 ”选项卡上的“ 字体 ”组中，选择“ 字体对话框启动器 ”。. 在“ 字体 ”选项卡上的“ 效果 ”下，选中“ 上标 ”或“ 下标 ”复选框。. 提示: 您可以在不更改字号的情况下设置 ...

Skype Support for All products | Skype Support

了解如何创建用于安装或重新安装 Windows 7、Windows 8.1 或 Windows 10 的安装介质。.

Post questions, follow discussions and share your knowledge in the Outlook.com Community. Hotmail is now Outlook.com. Learn how to sign in to access your Outlook.com, Hotmail, Live, or MSN email account.

support.skype.com

Windows 8.1. Whether you're writing a letter or calculating numerical data, your keyboard is the main way to enter information into your computer. But did you know you can also use your keyboard to control your computer? Learning a few simple keyboard commands (instructions to your computer) can help you work more efficiently.

Note: Some versions of Project don't have an associated Microsoft account, or work or school account, or you need to redeem your product key in a different way.See the following if this is how you got your version of Project Professional 2021, Project Professional 2019, Project Standard 2021, or Project Standard 2019: Microsoft Workplace Discount Program (formerly known as Home Use Program ...