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.
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.
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)
How to correct a #N/A error in the VLOOKUP function
The solution is to use a combination of INDEX and MATCH functions, which can look up a value in a column regardless of its location position in the lookup table. See the next section. Consider using INDEX/MATCH instead. INDEX and MATCH are good options for many cases in which VLOOKUP does not meet your needs.
LOOKUP function - Microsoft Support
Syntax. LOOKUP (lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments: lookup_value Required. A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value. lookup_vector Required.
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.
GETPIVOTDATA function - Microsoft Support
You can quickly enter a simple GETPIVOTDATA formula by typing = (the equal sign) in the cell you want to return the value to and then clicking the cell in the PivotTable that contains the data you want to return.
INDIRECT function - Microsoft Support
Syntax. INDIRECT (ref_text, [a1]) The INDIRECT function syntax has the following arguments: Ref_text Required. A reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string.
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.
FLOOR function - Microsoft Support
This article describes the formula syntax and usage of the FLOOR function in Microsoft Excel. Description. Rounds number down, toward zero, to the nearest multiple of significance. Syntax. FLOOR (number, significance) The FLOOR function syntax has the following arguments: Number Required. The numeric value you want to round. Significance Required.
VALUETOTEXT function - Microsoft Support
The VALUETOTEXT function returns text from any specified value. It passes text values unchanged, and converts non-text values to text. Syntax. VALUETOTEXT (value, [format]) The VALUETOTEXT function syntax has the following arguments. Note: If format is anything other than 0 or 1, VALUETOTEXT returns the #VALUE! error value. Examples.