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.

To reset your PC, go to Start > Settings > System > Recovery .Next to Reset this PC , select Reset PC.Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No.. Open Recovery settings

Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.

To open the Start menu—which contains all your apps, settings, and files—you can do any of the following: On the center or left end of the taskbar, select the Start icon.

In the list next to Personalize your background, select Picture, Solid color, Slideshow, or Windows Spotlight (to see a new image from around the world every day).

Unlike in previous versions of Windows, you’ll need to use the media creation tool to create an ISO file to install Windows 10. Make sure you have a license to install Windows 10, and then follow these steps:

Select Add a printer or scanner.. Wait for it to find nearby scanners, then choose the one you want to use and select Add device.

Learn Excel skills from beginner to advanced with video tutorials, templates, and tips from Microsoft Support.

If you're trying to add your Outlook.com account to Outlook or another mail app, you might need the POP, IMAP, or SMTP settings. You can find them below or by viewing them in your Outlook.com settings.. Outlook and Outlook.com may be able to detect your account's mailbox settings automatically, but for other non-Microsoft accounts, you may need to contact your email provider for their settings.

Features with audio and video functionality.. Many features that come as part of Windows can be used to view or play video or audio content. Here are some examples: OneNote app (lets people record or play audio), Microsoft Edge web browser (lets people play audio and video content on the internet), the Photos app, the OneDrive app, and others.