Excel Formula Generator

Build Excel formulas for VLOOKUP, IF, SUMIF, INDEX MATCH, and more, no formula knowledge needed.

Choose a Formula

Lookup

Logical

Math

Text

Date

VLOOKUP

Look up a value in the first column of a range and return a value from another column.

Lookup value

Table range

Column index

Exact match?

Generated Formula

=VLOOKUP(A2, B:D, 2, 0)

FAQ