Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of …
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.
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
LOOKUP function - Microsoft Support
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, …
Create, load, or edit a query in Excel (Power Query)
Create, load, or edit a query in Excel (Power Query) Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the …
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their …
FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
Count how often a value occurs - Microsoft Support
Use the COUNTIF function to count how many times a particular value appears in a range of cells. The COUNTIFS function is similar to the function with one important exception: …
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can …
IFERROR function - Microsoft Support
How to use the IFERROR function in Excel to trap and handle errors in a formula.