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. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

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.

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.

Record game clips and take screenshots. While you’re playing a game, press the Windows logo key + G to open Game Bar. Choose Widget Menu > Capture. Choose Start recording, Take screenshot, or Record last…. Record last… turns the most recent moments of play into a game clip when background recording is turned on.

Xbox subscription cancellations and refunds. Request a refund for digital games. Check your Xbox purchase history. Get help with purchase errors. Pre-order Xbox digital games in the Microsoft Store. Get help with a digital code or gift card.

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 IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

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.

Earn points toward rewards by doing the stuff you do every day. It’s easy and it’s free. All you need to do is sign up, and Microsoft Rewards will be included in your Microsoft account: Microsoft Rewards. Once you’ve signed up, sign in to your Microsoft account to see your current points.

Find your Windows settings in a snap! Select the Start button, then select Settings . From there, browse the categories or use search to find what you're looking for. Windows 11 Windows 10. Tips: Most apps have their own settings. In the app, select Settings to make app-specific changes.