Prompting for Basic Formulas

You don't need to memorize VLOOKUP syntax or remember SUMIF arguments. AI can write these formulas instantly when you describe what you need in plain English.

VLOOKUP Made Easy

Instead of memorizing: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Just describe what you want:

SUMIF and COUNTIF

These formulas are perfect for AI because the conditions can be complex:

The Magic Template

For any basic lookup or conditional formula, use this pattern:

I have [data description].
Column A: [what's in A]
Column B: [what's in B]
...

I want to [your goal].
Write the Excel formula for [specific cell].

Common Formulas AI Handles Well

• VLOOKUP/XLOOKUP - "Look up X and return Y"
• SUMIF/SUMIFS - "Sum values where condition is met"
• COUNTIF/COUNTIFS - "Count cells where condition is met"
• AVERAGEIF - "Average values where condition is met"
• INDEX/MATCH - "More flexible lookups"

Key Takeaway

You don't need to be an Excel expert. Describe your columns, describe your goal, and let AI handle the syntax. This works for any basic formula.