Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.

To delete a page that contains text, graphics, or empty paragraphs, select the content to delete, and press Delete.You can also do this:

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.

Look in the Surface app. The easiest way to find which Surface model you have is to use the Surface app. It shows the model name of your Surface device and each Surface accessory.

Notes: If you have existing lists of safe names and addresses, you can move that information into Outlook. Click Import from File and browse for the list file that you want. To create a file that uses your current list, click Export to File and then specify where you want the new file saved.. To change a name on the list, click the name that you want to change and then click Edit.

Learn how to access the Control Panel in Windows for managing your system settings and programs.

This troubleshooter assists customers whose machines are not yet updated to the latest release, Windows 10 Version 1607. This update will initially be released only to a small set of targeted customers. This set will expand over time. Windows users can start the assistant from this article.

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.

On the General tab, under Home page, enter the URL of the site you want to set as a homepage.You can add more than one URL. Or, to add the site you're currently viewing, select Use current.If you add more than one URL, put each URL on its own line.

Under Ways to sign in , you have three choices to sign in with Windows Hello:. Select Facial recognition (Windows Hello) to set up facial recognition sign-in with your PC's infrared camera or an external infrared camera