The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. 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.

Bluetooth: Activate and use any Bluetooth connections between your device and other devices. Calendar: Access your calendars. Call history: Access history of phone calls you made on the device, in Skype or other telephony apps. Contacts: Access your contacts, people, or address book apps.

You can wirelessly connect your PC to a TV, projector, or other kind of external display that supports Miracast. Turn on your TV, projector, or other display. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display.

Now you can seamlessly share files between your PC and mobile device when they are connected via Phone Link and the Link to Windows app. What do I need to share files between my PC and mobile device? A PC running Windows 10 (with the May 2019 update or later) or Windows 11. Android device running Android 9.0 or later.

Look up values with VLOOKUP, INDEX, or MATCH. HLOOKUP function. Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

Get help and support, whether you're shopping now or need help with a past purchase. Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.

Get help and support for Microsoft Edge. Find Microsoft Edge support content, how-to articles, tutorials, and more.

Windows Security provides built-in security options to help protect your device from malicious software attacks. To access the features described below, tap the Windows Start button, type windows security, select it from the results, and then select Device security.

Find your files in Windows 11 using one of these methods. Search from the taskbar: Type the name of a document (or a keyword from it) into the search box on the taskbar. You'll see results for documents across your PC and OneDrive.

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM (A2:A10) Adds the values in cells A2:10. =SUM (A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.