Dashboard/office/Excel & Sheets Formula Builder

Excel & Sheets Formula Builder

Visually assemble complex Excel and Google Sheets formulas like XLOOKUP, VLOOKUP, SUMIFS, and INDEX-MATCH.

Select Formula Type

Look up a value in the leftmost column of a table and return a corresponding value from another column.

Lookup Valuee.g. A2

Table Rangee.g. Sheet2!A1:D100

Return Column #e.g. 3

Exact Match? (FALSE/TRUE)e.g. FALSE

Generated Excel Formula

=VLOOKUP(A2, Sheet2!A1:D100, 3, FALSE)

How this formula works

Searches for the value in A2 across column A of Sheet2!A1:D100 and returns the value from the 3rd column.

Compatible with Microsoft Excel (2016 - 365) and Google Sheets.