Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.

In Windows 11, it is essential that you link your Microsoft account with the Windows 11 digital license on your device. Linking your Microsoft account with your digital license allows you to reactivate Windows using the Activation troubleshooter whenever you make a significant hardware change.

In PowerPoint 2016, you can insert an online video with an embed code or search for a video by name. Then you can play it during your presentation.

Notes: To set an automatic reply for contacts outside your company, select Outside My Organization > Auto-reply to people outside my organization, type in a message, and select OK.. The OK button may be missing because of certain screen solution and scaling settings. To resolve this issue, you can adjust the screen resolution and scaling settings, or use a large monitor.

Tip: If you've already set up speech recognition, pressing Windows logo key +Ctrl+S opens speech recognition and you're ready to use it. If you want to retrain your computer to recognize your voice, press the Windows logo key , type Control Panel, and select Control Panel in the list of results. In Control Panel, select Ease of Access > Speech Recognition > Train your computer to better ...

Turn on caret browsing indefinitely by going to Settings and more > Settings > Accessibility and turn on Navigate pages with a text cursor. With caret browsing on, you can move the caret within a web page using the Up, Down, Left, and Right directional arrow keys and Home, Page Up, and Page Down buttons on your keyboard.. To select text, images, or other elements on the page, hold down Shift ...

Notes: If you don't see Go to Microsoft Store on the Activation page, contact your organization's support person.. If you made a substantial hardware changes to your device (such as replacing the motherboard) and you have a valid product key, try to activate Windows by phone.

Tip: You can also format your text.Highlight a word or words in your title or questions, and then choose any of the following: Bold (keyboard shortcut - CTRL/Cmd+B), Italic (keyboard shortcut - CTRL/Cmd+I), Underline (keyboard shortcut - CTRL/Cmd+U), Font color, Font size, Numbering, or Bullets.

Ask for design ideas any time by choosing Design > Designer on the ribbon.. If Designer doesn't have any design ideas for you or you don't see the Designer button, there are a few possible reasons for that situation. Want to learn more about Designer?

Leave your Android device in your pocket the next time it rings — pick up the call from your PC instead. Calling requires Bluetooth capability on both your PC and on your Android device, so make sure you have it turned on for both.