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.

Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.

Important: You won't lose files or data by resetting OneDrive on your computer.Resetting OneDrive only disconnects all your sync connections (including personal and work or school).

Next to Reset this PC, select Reset PC and choose an option:. Keep my files—Reinstalls Windows 11 but keeps your personal files and any apps that came with your PC.This option removes changes you made to settings, as well as apps and drivers you installed.

Mismatched email domains- If the email claims to be from a reputable company, like Microsoft or your bank, but the email is being sent from another email domain like Gmail.com, or microsoftsupport.ru it's probably a scam.Also be watchful for very subtle misspellings of the legitimate domain name. Like micros0ft.com where the second "o" has been replaced by a 0, or rnicrosoft.com, where the "m ...

Press the Start button , and then enter store into the search bar.; Choose Microsoft Store from the results to open the app.; Select your account in the top-right corner of the screen, and then select Redeem code or gift cards.; Enter the 25-character code, select Next, and then follow the prompts.

When you click someone's name or picture in Outlook or other Office apps and services, you'll see their profile card with information about them. From their profile card, you can save them to your own contacts, for example if you want to add Notes or other information.

Tips: If you're using mobile data, try switching to Wi-Fi and vice-versa. Make sure Airplane mode is off.

Notes: You can either use an email address you own as a Microsoft account, or create a new address by choosing "Get a new email address" or "Use your email instead" when you sign up.

Verified IDs are secure trusted credentials that can be used by websites and organizations to make account setup simpler and safer. Usually, you'll use your device's camera to capture a QR code on the site to get a new Verified ID, or a verification of an ID already on your device.