Use the XLOOKUP function when you need to find things in a table or a 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 in touch with Microsoft Support for assistance with Microsoft products and services.

Get steps for connecting a Miracast wireless display. If pressing the Connect button in the action center doesn't find your device, try the troubleshooting steps provided at Fix connections to Miracast wireless displays.

Email a link to just a few people. Right-click (or press and hold) the file, select More OneDrive sharing options > Invite people, then enter their email addresses.(If you're using OneDrive for Business, select Share, select an option from the drop-down list box, and select Apply.Then enter email addresses above the blue line and select Send.)

Note If the price for your Xbox subscription has changed, it may be because the subscription renewed after a trial or promotional rate to the full rate. You should be notified ahead of time if the full rate for a subscription changes for your region.

A list of Excel training, from entry level to advanced skills, plus templates and other resources.

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 ...

You're typing along, you make a mistake, and you see the wavy red underline. You fix the mistake, but you've lost your flow, your idea. To avoid that distraction, you can turn spell check off, then check spelling manually when you're done writing.

如何启用 tpm. 如果需要启用 tpm，这些设置将通过 uefi bios (电脑固件) 进行管理，并且因设备而异。 可以通过选择“设置 >更新&安全性>恢复> 立即重启”来访问这些设置。 在下一屏幕中，选择“ 故障排除 > 高级选项 ”> “uefi 固件设置” > “重启 ”进行更改。 这些设置有时包含在 uefi bios 中标有 ...

To create a new, blank file and link to it, click Create New Document under Link to, type a name for the new file, and either use the location shown under Full path or browse to a different save location by clicking Change.You can also choose whether to Edit the new document later or open and Edit the new document now.