The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array. Use this form of LOOKUP when the values that you want to match are in the first row or column of the array.. Syntax. LOOKUP(lookup_value, array) The LOOKUP function array form syntax has these arguments:

Advanced email security. As a Microsoft 365 subscriber, you get enhanced security tools that help protect your inbox from phishing and malware.

Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.

Tip: If you believe someone has acquired your payment info, contact your bank or your payment provider to prevent more charges. Tell them your credit card has been stolen or compromised - If you only dispute the charges, there's nothing to prevent the fraudulent charges from happening again.

Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.

Get Microsoft 365 support, help, and learning resources. Organize your life, expand your creativity, and protect what’s important with Microsoft 365

Note: The scan creates a backup file during the repair process.To change the default name or location of this backup file, in the Enter name of backup file box, enter a new name, or choose Browse to select the file you want to use. You may need to run the tool several times in order to repair your Outlook Data File.

Create a group for your project or team. Create a PLC group in Outlook (Office 365 Education) A Professional Learning Community (PLC) group is a type of Microsoft 365 Group that provides a shared space for educators to use for collaboration.

Press the Start button on the taskbar, type settings, and then select Settings.; On Windows 10, select Update & Security.On Windows 11, select Windows Update.; On the Windows Update page, select Check for updates to see if any updates are available for your device.; Once the updates have downloaded, select Install now to start the installation.; Following installation, we recommend that you ...