How to Use the Excel Formula Builder
Mode A: Choose a formula type and fill in the fields — the formula builds as you type. Mode B: Describe what you need in plain English (e.g., "sum column D where column B says Sales") and get the exact formula.
Excel Formula Builder Formula
VLOOKUP(lookup_value, table_array, col_index, [range_lookup])range_lookup= 0 or FALSE for exact match (recommended); 1 or TRUE for approximate match
Example Calculation
Find price in column C based on product name in column A:
VLOOKUP(A2, $A$2:$C$100, 3, 0)
=VLOOKUP(A2,$A$2:$C$100,3,0)
Frequently Asked Questions
What is the difference between VLOOKUP and XLOOKUP?
XLOOKUP (Excel 365/2019+) is more powerful: it searches in any direction, returns arrays, has a built-in "not found" argument, and defaults to exact match. VLOOKUP is older but works in all Excel versions. Use XLOOKUP if your Excel supports it.