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.

Als je ondersteuning wilt krijgen in Outlook.com, klik je hier of selecteer je Help op de menubalk en voer je je query in. Als de zelfhulp uw probleem niet oplost, schuift u omlaag naar Hebt u nog steeds hulp nodig? en selecteer Ja.. Als je contact met ons wilt opnemen in Outlook.com, moet je je aanmelden. Als u zich niet kunt aanmelden, klikt u hier.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

Step 2: Back up your folders. Windows Backup is an easy, single stop for all of your backup needs. Your free Microsoft account comes with 5 GB of OneDrive cloud storage (and more storage is available if you need it), and backing up your folders syncs the folders you specify to your OneDrive account, making them instantly accessible on all computers that you use with this Microsoft account.

To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts.

USB-C overview. With a USB-C connection, you can charge your Windows 11 PC, and you can also connect to other USB Type-C devices such as mobile phones, docking stations, display adapters, and other devices that have a USB-C port.

Troubleshoot issues that occur when setting up external monitors. If you are trying to set up an external monitor and it’s not working, press the Windows logo key + P to make sure that the Extend option is selected. If the Extend option is selected, try the following troubleshooting tips.

Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.

If Windows Update finds an updated driver, it will download and install it, and your printer will automatically use it. If a device driver couldn’t be installed automatically, there may be an optional driver available that your printer can use.

Enter your Email, phone, or Skype name in the first box if you know it.; In the Contact email address text box, type an email address where we can contact you or send your password reset link. Note that this email address should be different from the one you’re trying to recover. In the third text box, type the characters displayed on the screen.