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.

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...

Learn how to download, install, and use the PC Health Check app to check your device's compatibility with Windows 11 and get tips to improve its performance.

Windows 10 in S mode is designed for security and performance, exclusively running apps from the Microsoft Store. If you want to install an app that isn't available in the Microsoft Store, you'll need to switch out of S mode.

注意: 无线显示应用在运行 Windows 11 版本 22H2 及更高版本的设备上可用。如果运行的是早期版本的 Windows，请在任务栏的搜索框中输入 “连接”，然后在结果列表中选择“连接”，从而启动 “连接” 应用。 若要了解正在运行的 Windows 版本，请参阅 我运行的是哪个版本的 Windows 操作系统？

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier.

To resize the image, select the image to see drag handles appear around the image. Move the drag handles to resize the image as necessary. Select the Picture Format tab on the ribbon, then use the options on it to format your image. For example, you can apply a style or a border to the image.

按住 Xbox 按钮 3 秒打开控制器。 打开控制器时，Xbox 按钮 将开始闪烁。 长按控制器顶部的的“配对”按钮 （凸起按钮）。 控制器上的 Xbox 按钮 将加速闪烁 - 这意味着控制器正在搜索电脑。; 在电脑上，按“开始”按钮 ，然后选择“设置” > 设备（在 Windows 11 上：设置 > 蓝牙和设备）。

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.