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 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Insert comments and notes in Excel - Microsoft Support
If you need to edit the note, right-click the cell, and then click Edit Comment.If you're using Excel for Office 365, right-click the cell and choose Edit Note.. If you need to delete the note, right-click the cell and choose Delete Comment.If you're using Excel for Office 365, right-click the cell and choose Delete Note.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile
What is the difference between POP and IMAP? - Microsoft Support
POP3 (Post Office Protocol) POP3 is an older protocol that was originally designed to be used on only one computer. Unlike modern protocols that use two-way synchronization, POP3 only supports one-way email synchronization, only allowing users to download emails from a server to a client.
Applies To: Outlook for Android, Outlook for iOS
Search indexing in Windows: FAQ - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Personalize your PC - Microsoft Support
Windows themes A theme is a combination of pictures, colors, and sounds that help you personalize your PC. The latest versions of Windows include many exciting desktop personalization features, such as panoramic themes that extend across two side-by-side monitors, and the ability to have your theme appear on your Start screen.
Insert a picture in PowerPoint - Microsoft Support
Insert clip art. Unlike some earlier versions of PowerPoint, newer versions don't have a clip art gallery. Instead, use Insert > Online Pictures to find and insert clip art using the Bing search tool.. For example, after you select Online Pictures, you might search for horse clip art and see a variety of images under a Creative Commons license.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2024, PowerPoint 2024 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016, PowerPoint for iPad, PowerPoint for iPhone, PowerPoint for Android tablets, PowerPoint for Android phones
Best practices for Outlook - Microsoft Support
Regardless of your server setup or organization size, this document will be useful to you. For IT administrators. Sentences prefaced with the Microsoft 365 logo are references to other Microsoft 365 products, such as Microsoft OneNote, and Microsoft SharePoint Server. Sentences that mention AutoArchive and Outlook Data Files (.pst) are marked with an icon of a folder and file .
Applies To: Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016
Count unique values among duplicates - Microsoft Support
You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Windows camera, microphone, and privacy - Microsoft Support
In Windows 11, ensure that Camera access, Let apps access your camera, and the individual toggle for the Microsoft Store app you wish to use is turned on. If you do not see the app or website you're looking for in the list, it's likely a desktop app. Desktop apps cannot be individually toggled, but access for those apps can be controlled using Let desktop apps access your camera.
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