Syntax. MATCH(lookup_value, lookup_array, [match_type]) The MATCH function syntax has the following arguments: lookup_value Required.The value that you want to match in lookup_array.For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.

To select. Do this. A single sheet. Click the sheet tab. If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.

Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.

When you click a link to an email address, your email program automatically starts and creates an email message with the correct address in the To box, provided that you have an email program installed.. On a worksheet, click the cell where you want to create a link.

Join a Teams meeting on the web. Don't have the Teams app? You can still join a Teams meeting. In your email invite, select Join the meeting now.. You can also use a dial-in number and conference ID from the email to call in.

Create, edit and share documents with Microsoft Word online. Learn how to use Word for the web to create, open, and rename documents with ease.

Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.

Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.

Learn how to tell if your Office software is genuine. To help determine if your Microsoft software is genuine, go to our How to Tell site for more information. Here you'll learn about authentic packaging, including what to look for with product key labels, and Certificate of Authenticity (COA), how to report counterfeit software, and find out what your shopping and licensing options are.