Lookup & Reference
★ 100 · ◉ 18 · Excel 2021
=XLOOKUP()
Use the XLOOKUP function when you need to find things in a table or a 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. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
Daily Tasks
Lookup & Retrieval
Math & Trig
★ 100 · ◉ 16 · All versions
=SUM()
How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.
=SUM(number1,[number2],...)
Daily Tasks
Reporting
Logical
★ 95 · ◉ 19 · All versions
=IF()
How to use the IF function in Excel to make logical comparisons between data values.
=IF(logical_test, value_if_true, [value_if_false])
Daily Tasks
Conditional Logic
Lookup & Reference
★ 95 · ◉ 12 · All versions
=INDEX()
Returns the value of an element in a table or an array, selected by the row and column number indexes. Use the array form if the first argument to INDEX is an array constant. Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of non-adjacent selections, you can pick the selection to look in.
=INDEX(array, row_num, [column_num])
Daily Tasks
Lookup & Retrieval
Statistical
★ 90 · ◉ 22 · All versions
=MAX()
Returns the largest value in a set of values.
=MAX(number1, [number2], ...)
Daily Tasks
Reporting
Statistical
★ 90 · ◉ 15 · All versions
=MIN()
Returns the smallest number in a set of values.
=MIN(number1, [number2], ...)
Daily Tasks
Reporting