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.

To recall and replace a message in new Outlook. Select Sent Items in the left folder pane, then double-click the sent message to open it in a separate window. From the ribbon, select Recall Message, then select OK in the confirmation dialog box. Shortly thereafter, you'll receive a Message Recall Report in your inbox.

Enable virtualization on Windows 11 PCs. Virtualization lets your PC emulate a different operating system, like Android™ or Linux. Enabling virtualization gives you access to a larger library of apps to use and install on your PC. If you upgraded from Windows 10 to Windows 11 on your PC, these steps will help you enable virtualization.

Customize your lock screen status. Select Start > Settings . Select Personalization > Lock screen. Select the list for Lock screen status and select an app that can show detailed status on the lock screen. You can also select None if you don't want to see detailed status on the lock screen. Note: Lock screen status will be available when you ...

Get a theme. To get a theme, expand one of the categories below, select a link for the theme, and then select Open. This saves the theme to your PC and puts it on your desktop. If you prefer, some themes can also be installed from the Microsoft Store. Explore themes in the Microsoft Store. Get free Windows themes from Microsoft to personalize ...

Alt+0299. Alt+0332. Alt+0333. Alt+0362. Alt+0363. Notes: If you're working on a laptop without a separate numeric keyboard, you can add most accented characters using the Insert > Symbol > More Symbols command in Word. For more info, see Insert a symbol in Word.

If that doesn't work, or your camera is built in on your device, try this: Select Start , type device manager, then select it from the search results. Find your camera under Cameras, Imaging devices , or Sound, video and game controllers. If you can't find your camera, select the Action menu, then select Scan for hardware changes.

Select Start > Settings > Time & language > Language & region. Under Preferred languages, select the language that contains the keyboard you want, and then select Options. Select Add a keyboard and choose the keyboard you want to add. If you don't see the keyboard you want, you may have to add a new language to get additional options.

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

Select the Classic Outlook tab and follow those steps instead. On the View tab, select View settings in new Outlook. Select Accounts > Automatic Replies . Select the Turn on automatic replies toggle. Select Send replies only during a time period, and then enter start and end times. Under Send automatic replies inside your organization, enter ...