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

OneDrive not connected. If you cannot sign in to your OneDrive sync app, or you see a message saying OneDrive is not connected, let our troubleshooter guide you through the steps to get syncing again, or follow the steps below.

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)

Learn how to add a printer or scanner in Windows. If your printer connects by a wire, plug it into your device. It'll connect automatically, your PC will download the right drivers, and you can use it right away.

Summary. Windows 10, versions 2004, 20H2, 21H1, 21H2, and 22H2 share a common core operating system with an identical set of system files. Therefore, the new features in Windows 10, version 22H2 are included in the latest monthly quality update for Windows 10, version 2004, 20H2, 21H1, and 21H2 but are in an inactive and dormant state.

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.

Learn how to format text, add graphics, and more in Word documents. Create professional-looking documents with ease using our step-by-step guide. Try it now!

After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

We want to hear from you! Please continue to share your feedback with us — either in the Google Play Store, directly in the Phone Link and Link to Windows apps, or at the bottom of this article.

To change your translation preferences, go to Home > Translate > Translation Preferences.. Here you can set your preferred language. Translate part of an email. To translate just a bit of text from a message, select that text and right-click.