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.

Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.

注意: 如果使用 Microsoft 帐户 （例如 Outlook.com 、Hotmail、Live 或 MSN 电子邮件帐户）而不是工作或学校帐户登录，请注销，然后使用正确的帐户重新登录。 不确定使用哪个帐户登录？ 在 Outlook 导航标头中选择 “帐户管理员 ”。 如果未使用所需帐户登录，请选择“ 注销 ”并重新开始该过程，或选择 ...

MSN provides you with three quick ways to navigate through MSN to easily find what you need: The Mega menu located at the top left side of the page, brings you every section in just one easy step.

If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.

Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, click Settings, and then click Change PC settings.)

Set up PC folder backup. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help & Settings icon then Settings.). Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)

Country/region. Microsoft Store sales support. Technical or download support. Egypt +20 2 353 3333. Technical support. South Africa. 0800 167 344. Technical support

A guide to help you identify and access your Microsoft account. How to check if your email is a Microsoft account? Go to the Microsoft account sign-in page at https://account.microsoft.com and enter your email address.

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.