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.

In the Add-Ins dialog box, select the check boxes the add-ins that you want to use, and then click OK. If Excel displays a message that states it can't run this add-in and prompts you to install it, click Yes to install the add-ins. For more information about how to use add-ins, see Add or remove add-ins.

If installation doesn't start automatically, browse the disc to find the program setup file, usually called Setup.exe or Install.exe. Open the file to start installation.

Make boards read-only when needed. If you started your whiteboard in a Microsoft Teams meeting or channel, you can choose to put it in read-only mode whenever you want your co-workers or students to stop collaborating on it.

Using Authenticator as a way to sign in. If you have turned on passwordless, two-step, or multi-factor authentication for your account, use the following steps to sign-in:

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.

On the Choose an account screen, click the Microsoft account button.; On the Add your Microsoft account screen, enter the email address and password associated with your Microsoft account.; On the Make it yours screen, you'll have the option to make this Microsoft account your primary account. (This makes sign-in, settings, and syncing happen automatically for all other Microsoft services.)

Download and install the My Apps Secure Sign-in Extension. Download and install the My Apps Secure Sign-in Extension, if you're prompted. This extension helps you use your desktop browser to use single sign-on with your organization's cloud apps.

Wait for it to find nearby printers, then choose the one you want to use, and select Add device.If you want to remove the printer later, select it, and then select Remove.