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, let's say you know the part number for an auto part, but you don't know the price.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. 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.
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 employee ID.
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.
VLOOKUP function - Microsoft Support
Use the VLOOKUP function to look up a value in a table. The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. Lookup_value can be a value or a reference to a cell.
AGGREGATE function - Microsoft Support
Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values. AGGREGATE (function_num, options, ref1, [ref2], …) AGGREGATE (function_num, options, array, [k]) The AGGREGATE function syntax has the following arguments:
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.
Calculation operators and precedence in Excel - Microsoft Support
There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference. To perform basic mathematical operations such as addition, subtraction, or multiplication—or to combine numbers—and produce numeric results, use the arithmetic operators in this table.
Guidelines and examples of array formulas - Microsoft Support
In the two row array, the first row is 1, 2, 3, and 4, and the second row is 5, 6, 7, and 8. A single semicolon separates the two rows, between 4 and 5. As with array formulas, you can use array constants with most of the built-in functions that Excel provides.
HLOOKUP function - Microsoft Support
This article describes the formula syntax and usage of the HLOOKUP function in Microsoft Excel. Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
Round a number to the decimal places I want - Microsoft Support
Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or ones. The ROUNDUP and ROUNDDOWN functions alre also explained.