How to correct a #N/A error in the VLOOKUP function
网页If your lookup value is not in the first column of the array, you will see the #N/A error. In the following table, we want to retrieve the number of units sold for Kale. The #N/A error results because the lookup value “Kale” appears in the second column (Produce) of the table_array argument A2:C10.
Remove or allow a circular reference - Microsoft Support
网页Learn about the circular reference warning message. The first time Excel finds a circular reference, it displays a warning message. Select OK or close the message window. When you close the message, Excel displays either a zero or the last calculated value in the cell.
MIRR function - Microsoft Support
网页MIRR (values, finance_rate, reinvest_rate) The MIRR function syntax has the following arguments: Values Required. An array or a reference to cells that contain numbers. These numbers represent a series of payments (negative values) and income (positive values) occurring at regular periods.
COUNTIFS function - Microsoft Support
网页COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: criteria_range1 Required. The first range in which to evaluate the associated criteria. criteria1 Required.
Reapply a filter and sort, or clear a filter - Microsoft Support
网页Filter data in a range or table. Sort data in a range or table. After you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or perform a sort operation to get up-to-date results, or you can clear a filter to redisplay all the data.
Access your Account Privacy Settings - Microsoft Support
网页Go to the File tab, select Account (or Office Account in Outlook) in the bottom of the left pane, and then choose Manage Settings. To access your privacy settings in the new Outlook for Windows: On the View tab, select View settings and choose General. Select Privacy and data then choose Privacy settings.