LOOKUP function - Microsoft Support
Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
External or guest sharing in OneDrive, SharePoint, and Lists
If you want to secure your content and get a link that only works for the people you invite, select Specific people in Link settings when creating the sharing link.. The recipients' experience depends on the settings you select when creating the sharing link, and the account they use to view the file.
Applies To: Microsoft Lists, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
Anmelden bei Outlook im Web - Microsoft-Support
Hinweis: Wenn Sie sich mit einem Microsoft-Konto wie einem Outlook.com-, Hotmail-, Live- oder MSN-E-Mail-Konto anstelle Ihres Geschäfts-, Schul- oder Unikontos angemeldet haben, melden Sie sich ab, und melden Sie sich dann erneut mit dem richtigen Konto an. Sie sind nicht sicher, mit welchem Konto Sie angemeldet sind? Wählen Sie im Outlook-Navigationsheader Konto-Manager aus.
Applies To: Office for business, Office 365 Small Business, Outlook on the web, Outlook on the web for Exchange Server 2016
Before you sell or gift your Xbox or Windows pc - Microsoft Support
Under Reset this PC, select Get started, and then follow the instructions on the screen.Resetting your device removes your files, settings, and apps, then reinstalls Windows.
Applies To: Microsoft account dashboard
What version of Outlook do I have? - Microsoft Support
There are now two versions of Outlook for Windows: new Outlook for Windows and classic Outlook for Windows. To determine if the Outlook for Windows version you're using is new Outlook or classic Outlook, check if there's a File tab on the ribbon. If File doesn't appear, you're using new Outlook.If you have a File tab, you're using classic Outlook.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook Web App
How to redeem Microsoft Rewards points - Microsoft Support
Note: Offers vary by country.Be sure to redeem your rewards points in the same region you signed up in. Do not use a VPN while trying to redeem points. When redeeming points, use a mobile or landline phone number for authentication and not a VoIP phone number.
Applies To: Microsoft account dashboard
Change settings in Microsoft Teams - Microsoft Support
Change Teams settings. Teams will reflect the same date and time format as your device's language, date, and time settings. For example, if your device's display language is set to English (United States), the date and time in Teams will display the regional format used in the United States.. Change your language settings
Applies To: Microsoft Teams
Create a flow chart with SmartArt - Microsoft Support
To add a picture, in the box you want to add it to, click the picture icon , select the picture you want to display in the chart, and then click Insert.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
DVD playback options for Windows - Microsoft Support
Find out how to get a DVD player app, add-on, or plug-in, or whether you can upgrade your edition of Windows to add DVD playback.
Free up space for Windows updates - Microsoft Support
Windows 10 updates provide the latest features and security improvements to help keep your PC more current and more secure. Before the installation process starts, Windows checks to make sure there’s enough storage space on your device for the installation process and for these new features and security improvements.