使用 vlookup、hlookup 和其他函数（如 index 和 match）根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup，然后链接到更多内容。

To learn more about changing mic settings in Microsoft Teams (free), see Manage your device settings in Microsoft Teams (free). Check your microphone. Some devices have a physical mute option on the device itself, so check that your headphone boom is not in the mute position (usually upright or away from your mouth), or that your external mic's physical mute button is not turned on.

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

症状. _xlfn。 prefix 显示在公式中的函数前面。 计算公式时，会显示 #NAME？ 。 原因. Excel 工作簿包含当前运行的 Excel 版本中不支持的函数。

Get help and learn how to use Skype with Microsoft's official support page.

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)

Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.

若要在 Outlook.com 中获取支持，请单击此处或选择菜单栏上的帮助，然后输入查询。 如果自助服务无法解决问题，请向下滚动到“仍需要帮助？”，然后选择“是”。 若要在 Outlook.com 中联系我们，需要登录。

Select this option to import Internet Explorer Browsing History into Microsoft Edge. Because the Top sites shown in the New tab page are generated based on the browsing history in Microsoft Edge, you may see the Top sites change based on the imported history data.

If you turn on the Microsoft account setting for Cloud content search, Windows Search will show results from items in your personal OneDrive, Outlook, and other Microsoft services.If you search the web or get web search suggestions with Windows Search, Bing will personalize your results. You can also earn Microsoft Rewards points when you search with Bing in the Windows search box.