SWITCH function - Microsoft Support
Applies To. The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
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. =IF (Something is True, then do something, otherwise do something else)
Check if a cell contains text (case-insensitive) - Microsoft Support
Find cells that contain text. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell. On the Home tab, in the Editing group, click Find & Select, and then click Find.
Use AND and OR to test a combination of conditions
This formula nests the AND function inside the OR function to search for units sold between April 1, 2011 and January 1, 2012, or any units sold by Nancy. You can see it returns True for units sold by Nancy, and also for units sold by Tim and Ed during the dates specified in the formula.
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.
FIND, FINDB functions - Microsoft Support
If you don't want to do a case sensitive search or use wildcard characters, you can use SEARCH and SEARCHB. If find_text is "" (empty text), FIND matches the first character in the search string (that is, the character numbered start_num or 1).
Create conditional formulas - Microsoft Support
You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check. value_if_true: The value to return if the condition is True.
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: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Filter by using advanced criteria - Microsoft Support
Filter by using advanced criteria. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog box, click Data > Advanced.
XLOOKUP function - Microsoft Support
Syntax. The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match. =XLOOKUP (lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) Examples.
Using Checkboxes in Excel - Microsoft Support
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox.