Excel Formula Generator

Generate Excel and Google Sheets formulas from templates. Pick a formula type, fill in the fields, and copy the result straight into your spreadsheet.

Formula Type

Tips for writing cell references

Use A2 for a single cell, A2:A100 for a range
Add $ to lock a reference: $A$2 won't shift when you copy the formula
Reference another sheet: Sheet2!A2
In Google Sheets, you can reference another file with IMPORTRANGE

VLOOKUP vs INDEX/MATCH

VLOOKUP is simpler but requires the lookup column to be on the left. INDEX/MATCH is more flexible — it can look up any column in any direction, and is faster on large datasets.