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.

注意: 在Windows中获取驱动程序更新的最佳和最安全的方法始终是通过Windows 更新。如果在Windows 更新时遇到问题，则可能会看到 Update Windows 中的任何链接是否可帮助你先解决问题。

The scheduling form is where you'll give your meeting a title, invite people, and add meeting details. Use the Scheduling Assistant to find a time that works for everyone.. In Scheduling Assistant, you can see attendees' time zones, schedules, and availability during different timeslots. The Scheduling Assistant grid will show each attendee's schedule.

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.

Test your camera with the Camera app. Select Start , then choose Camera from your apps. If you're asked to allow access to the Camera, select Yes.If the camera works in the Camera app, the problem might be with the app you're trying to use.

Note: To let a user enter percentages, for example 20%, select Decimal in the Allow box, select the type of restriction that you want in the Data box, enter the minimum, maximum, or specific value as a decimal, for example .2 , and then display the data validation cell as a percentage by selecting the cell and clicking Percent Style in the Number group on the Home tab.

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

Here's how to show icons, hide them, or change their size in Windows. To show or hide desktop icons. Right-click (or press and hold) the desktop, point to View, and then select Show desktop icons to add or clear the check mark.

Get more out of your email with Outlook.com. We've streamlined search to make it easier than ever to find what you're looking for. New features like Files and attachment previews let you see your pictures and files without leaving your inbox.

2. Install any applicable firmware updates. If you have a Surface device, see Security issue for TPM on Surface devices for more information and instructions.. If your device is not from Microsoft, locate the device manufacturer of your device in the following table, select the corresponding link, and apply the firmware update that's provide.