How to correct a #N/A error in the VLOOKUP function
Correct the #N/A errorin the VLOOKUP function. INDEX and MATCH offers more flexibility with matches. INDEX and MATCH can find an exact match, or a value that is greater or lesser than the lookup value.
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, Excel for Windows Phone 10
Your account settings are out-of-date in Mail or Calendar for Windows ...
Microsoft has added OAuth support for Yahoo! accounts in the Windows 10 Creators update. To install the Creators Update now, go to the software download site, and select Update now.For more information about the update, see Windows 10 Creators Update is here.. If you have a Japanese Yahoo! email account you will need to do the following:
Applies To:
Calendar for Windows 10, Mail for Windows 10
Insert or delete rows and columns - Microsoft Support
Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
WORKDAY function - Microsoft Support
Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
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
Set up email in the Outlook for Android app - Microsoft Support
If you're having trouble using the Outlook for Android mobile app, Open an in-app Outlook support ticket. If you have a work or school account that uses Microsoft 365 for business or Exchange-based accounts, there may be additional requirements set by your IT admin.
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 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook.com, New Outlook for Windows
Update to the new Microsoft Edge - Microsoft Support
To change appearance, select Appearance and make the changes you want to your default theme, zoom, toolbar, and fonts.
Protect a worksheet - Microsoft Support
Option. Allows users to. Select locked cells. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells. Select unlocked cells
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use live captions to better understand audio - Microsoft Support
Choose either Above screen, Below screen, or Overlaid on screen.. When you choose Above screen or Below screen, the captions window will appear as docked to the top or bottom screen edges in reserved space on your desktop, and other apps will not be blocked by the captions window.When docked to the top, you might find that live captions works well while sharing video in a virtual meeting or ...
Contact Us - Microsoft Support
Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.