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.

Loop access via Microsoft 365 subscriptions. Certain features of Microsoft Loop are licensed and made available as part of different Microsoft 365 plans. Select your account type to learn more: The Loop apps for iOS, Android, and the web are available to anyone with a personal Microsoft account.

For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps. On the Microsoft 365 subscription tab, select Manage. From here you can: Renew your subscription with a prepaid code or card. Learn more.

You get the following error code and message when you try to use a game or app on your Xbox console: 0x803F9006. The person who bought this needs to sign in. This may mean we’re having trouble checking usage rights.

While you can drag content between your phone and your PC, not all apps will accept content you want to transfer. If an app doesn’t accept your content, you can try using phone screen to transfer it instead. You can’t drag and drop files between your mobile apps from your PC.

Remote Assistance Support from Microsoft allows a Microsoft support professional in another location to view your computer screen and work on your computer over a secured connection. Protect yourself from tech support scams. Before clicking 'I accept', review the: Agreement for Microsoft Services. Microsoft Software License Terms.

Learn how to remove malware from your PC. Use Microsoft Defender Antivirus in Windows 10 or Windows 11 to scan your PC for malware, viruses, or other threats.

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.

You see the following error codes when you try to launch a game or app on your Xbox console: 0x87e10bef. This may mean that your console needs a power cycle, or that the content is owned by another account. To resolve this error, try the solutions below.

To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. Here’s how to learn more: Select Start > Settings > System > About . Open About settings.