VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
Using IF with AND, OR, and NOT functions in Excel
Use the IF function along with AND, OR and NOT to perform multiple evaluations if conditions are True or False. The value that you want returned if the result of logical_test is TRUE. The value that you want returned if the result of logical_test is FALSE. Here are overviews of how to structure AND, OR and NOT functions individually.
How to correct a #N/A error in the VLOOKUP function
Solution: You can try to fix this by adjusting your VLOOKUP to reference the correct column. If that’s not possible, then try moving your columns.
Remove or allow a circular reference in Excel - Microsoft Support
To fix the problem, you can move the formula to another cell. Press Ctrl+X to cut the formula, select another cell, and press Ctrl+V to paste it. At times, you may want to use circular references because they cause your functions to iterate. If this is the case, jump down to Learn more about iterative calculation.
Overview of formulas in Excel - Microsoft Support
Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
How to correct a #VALUE! error in the IF function
When there is a cell reference to an error value, IF displays the #VALUE! error. Solution: You can use any of the error-handling formulas such as ISERROR, ISERR, or IFERROR along with IF. The following topics explain how to use IF, ISERROR and ISERR, or IFERROR in a formula when your argument refers to error values. Notes:
Dynamic array formulas and spilled array behavior - Microsoft …
Excel formulas that return a set of values, also known as an array, return these values to neighboring cells. This behavior is called spilling. Formulas that can return arrays of variable size are called dynamic array formulas. Formulas that are currently returning arrays that are successfully spilling can be referred to as spilled array formulas.
Display or hide zero values - Microsoft Support
Whether your format standards or preferences call for zeroes showing or hidden, there are several ways to make it happen. Go to File > Options > Advanced. To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
How to correct a #SPILL! error - Microsoft Support
This error occurs when the spill range for a spilled array formula isn't blank. Select the formula to reveal a dashed border that indicates the intended spill range. By selecting the formula, an error checking alert will appear.