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

Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.

Tip: In Windows 7, you can synchronize your computer clock with an Internet time server to keep the computer clock up to date.To do this, select the date or time in the bottom right-hand corner of your screen, and then select Change date and time settings.Select the Internet Time tab, select Change settings, select Synchronize with an Internet time server, and then select Update now.

Outlook won't accept my password. If you've forgotten the password for a Microsoft account, user our sign-in helper to get back into your account.. If you know you’re using the correct password for your email account but Outlook won’t accept it, you might have an email account that requires additional security.

Tips: If you don't see the OneDrive icon, OneDrive might not be running. On a PC, go to Start, type OneDrive in the search box, and then click OneDrive in the search results. You might need to click the Show hidden icons arrow next to the notification area to see the OneDrive icons. On a Mac, use Spotlight to search for OneDrive and open it.

You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

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.

The FILTER function allows you to filter a range of data based on criteria you define.

Note: Exporting and importing a mailbox using a .pst file isn't supported in new Outlook at this time. To export a mailbox, you need to use the desktop version of Outlook (also known as classic Outlook) following the steps below.Classic Outlook is included with Microsoft 365 subscriptions that include desktop apps such as Microsoft 365 Personal or Family or Microsoft 365 Business Standard, and ...

Scenario. Description. Recommended Solution. Add Teams meeting add-in for Outlook. Helps fix the issue where teams meeting add-in is missing or is not loaded, preventing you from creating teams meeting from Outlook.