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.

Sign in to SharePoint. SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.

You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

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.

Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.

1. Check your speaker output. 2. Run the audio troubleshooter. 3. Verify that all Windows Updates are installed. 4. Check your cables, plugs, jacks, volume, speaker, and headphone connections. 5. Check sound settings. 6. Fix your audio drivers. 7. Set your audio device as the default device. 8. Turn off audio enhancements. 9. Restart Audio Services

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.

Select Start > Settings > System > About . Open About settings. Under Device specifications > System type , see if you're running a 32-bit or 64-bit version of Windows. Under Windows specifications, check which edition and version of Windows your device is running.

If you pre-ordered a game and want to cancel, you can do so up to 10 days before the game launches at: Order history. After this time, you may be billed, and you’ll need to request a refund to cancel your order. For more info about digital game pre-orders, see: Pre-order Xbox digital games in the Microsoft Store.

The Microsoft Wireless Display Adapter is a strong, reliable way to project your content, photos, and videos to a big screen. Before you begin. Identify your wireless display adapter model. Check which devices are compatible with your adapter. Set up your adapter. Connect the adapter to your display. Connect to your adapter from your Windows PC.