Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: …
Quick Reference Card: VLOOKUP troubleshooting tips
Print a list of tips and techniques for avoiding #N/A and other errors in VLOOKUP.
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.
Lookup and reference functions (reference) - Microsoft Support
Searches a range or an array and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. Returns the …
How to correct a #N/A error in INDEX/MATCH functions
When the MATCH function does not find the lookup value in the lookup array, it returns the #N/A error. If you believe that the data is present in the spreadsheet, but MATCH is unable to locate …
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 …
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 …
How to correct a #VALUE! error - Microsoft Support
#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and …
Fix an inconsistent formula - Microsoft Support
This error means that the formula in the cell doesn't match the pattern of the formulas nearby.
Filter by using advanced criteria - Microsoft Support
When filtering text data, Excel doesn't distinguish between uppercase and lowercase characters. However, you can use a formula to perform a case-sensitive search. For an example, see the …