Excel Formula Helper

Find and understand Excel formulas with examples and explanations. Perfect for both beginners and advanced users.

VLOOKUPLookup & Reference

Searches for a value in the first column of a table array and returns a value in the same row from another column.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

VLOOKUP("Apple", A2:C10, 2, FALSE)

Looks for "Apple" in the first column of range A2:C10 and returns the corresponding value from the second column.

Result: Returns the exact match from column 2

VLOOKUP(A2, $B$2:$D$100, 3, TRUE)

Looks for the value in A2 within the first column of range B2:D100 and returns an approximate match from the third column.

Result: Returns the closest match (less than or equal to lookup value) from column 3

Adds all the numbers in a range of cells.

SUM(number1, [number2], ...)

SUM(A1:A10)

Adds all numbers in the range A1 through A10.

Result: Total sum of the range

SUM(A1:A10, C1:C10)

Adds all numbers in both ranges A1:A10 and C1:C10.

Result: Combined sum of both ranges

Returns one value if a condition is true and another value if it is false.

IF(logical_test, value_if_true, value_if_false)

IF(A1>10, "High", "Low")

If A1 is greater than 10, returns "High", otherwise returns "Low".

Result: "High" or "Low" based on condition

IF(B1="Yes", 100, 0)

If B1 equals "Yes", returns 100, otherwise returns 0.

Result: 100 or 0 based on condition

About Excel Formula Helper: