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.

Manage invitations to share Microsoft 365. On the Microsoft account, Sharing page, under the section Other people, you can view and manage invitations you’ve created.You can check the status of an invitation, resend, or delete invitations. If the person you sent an invitation to can't find it, see Can't find an invitation to share Microsoft 365 Family.

Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form.It allows you to split across columns or down by rows.

Learn how to manage extensions in Microsoft Edge, including adding, disabling, or removing them as needed.

In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").

Email addresses and phone numbers associated with your Microsoft account are called aliases and they use the same contacts, online storage, subscriptions, and account settings.

The steps to access the repair tool vary depending on your operating system. Right-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu.

Do one of the following: If you've never used Easy Connect, select Use Easy Connect.. If you've used Easy Connect before, select your helper’s contact name. To invite someone who isn't on your contact list, select Invite someone to help you.

Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, click Settings, and then click Change PC settings.)

Under Microsoft Defender Firewall, switch the setting to On.If your device is connected to a network, network policy settings might prevent you from completing these steps. For more info, contact your administrator.