VLOOKUP is one of the most powerful and most misunderstood functions in Excel and Google Sheets. If you've ever opened a spreadsheet and felt lost when someone asked you to "just VLOOKUP it," this guide is for you. By the end, you'll understand exactly how VLOOKUP works, when to use it, and when to use something better.

What VLOOKUP Actually Does

VLOOKUP stands for "Vertical Lookup." It searches for a value in the first column of a table, then returns a value from another column in the same row. Think of it like looking up a phone number in a phone book — you find the name first, then read across to get the number.

The basic syntax is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Each part does something specific. The lookup_value is what you're searching for. The table_array is where you're searching. The col_index_num tells Excel which column has your answer. And range_lookup decides whether you want exact or approximate matches.

Your First VLOOKUP: A Simple Example

Imagine you have a list of products in column A and their prices in column B. You want to find the price of "Apple." Here's the formula:

=VLOOKUP("Apple", A2:B100, 2, FALSE)

This searches for "Apple" in column A, looks at the matching row, and returns whatever is in column 2 (which is column B, the price). The FALSE at the end is critical — it means "find an exact match." Always use FALSE unless you have a very specific reason not to.

The Most Common VLOOKUP Mistakes

Even experienced users make these mistakes regularly:

Forgetting FALSE for Exact Match

If you leave off the last argument or set it to TRUE, Excel does an "approximate match" which requires your data to be sorted. If it's not sorted (and most data isn't), you'll get wildly incorrect results that look correct at first glance.

Using Wrong Column Index

The column index is counted from the leftmost column of your table_array, not from column A of your spreadsheet. If your table starts at column D and you want data from column F, the index is 3 (not 6).

Not Locking Cell References

When you copy a VLOOKUP formula down a column, the table_array reference shifts. Use absolute references like $A$2:$B$100 to keep it locked in place.

When VLOOKUP Isn't the Right Tool

VLOOKUP has one major limitation: it can only search the leftmost column. If your "lookup value" is in column C and you want a result from column A, VLOOKUP won't help. You'll either need to rearrange your data or use INDEX/MATCH or XLOOKUP instead.

The Modern Alternative: XLOOKUP

If you have Excel 2021 or Microsoft 365, you have access to XLOOKUP — which is essentially VLOOKUP without the limitations. It can search any column, return any column, and handles errors more gracefully. Syntax: =XLOOKUP(lookup_value, lookup_array, return_array).

For Google Sheets users, XLOOKUP is also available and works identically.

Real-World VLOOKUP Examples

Employee Lookup

Find an employee's department from their ID: =VLOOKUP(A2, Employees!A:D, 4, FALSE)

Price List

Look up product prices in an order form: =VLOOKUP(B2, PriceList!A:C, 3, FALSE)

Translating Codes

Convert region codes to region names: =VLOOKUP(D2, RegionTable, 2, FALSE)

Pro Tips for Cleaner VLOOKUPs

Wrap your VLOOKUP in IFERROR to handle missing values gracefully: =IFERROR(VLOOKUP(A2, B:C, 2, FALSE), "Not found"). This way instead of seeing #N/A errors, you get a clear message.

Use named ranges to make formulas easier to read. Instead of VLOOKUP(A2, B$2:D$100, 3, FALSE), define "Products" as your range and write VLOOKUP(A2, Products, 3, FALSE).

Key Takeaways

• Always use FALSE for exact matches
• The column index counts from your table's first column, not column A
• Use absolute references when copying formulas
• Wrap with IFERROR to handle missing data
• Consider XLOOKUP if available — it's simply better

VLOOKUP is a fundamental skill for anyone working with spreadsheets. Master it, and you'll save hours every week. Need help building a specific VLOOKUP formula? Try our free formula generator — describe what you want in plain English and we'll build it for you instantly.

If you're new to Excel or Google Sheets, the sheer number of available functions can feel overwhelming. There are hundreds of them. The good news? You only need to master about ten to handle 80% of your daily spreadsheet work. Here they are, with real examples for each.

1. SUM — Add Numbers Together

The most basic and most used function. SUM adds up all the numbers in a range.

Syntax: =SUM(range)

Example: =SUM(A1:A10) adds all numbers from A1 to A10. You can also add multiple ranges: =SUM(A1:A10, C1:C10).

Pro tip: Press Alt + = to instantly insert a SUM formula for the selected range.

2. AVERAGE — Calculate the Mean

AVERAGE returns the arithmetic mean of a range, ignoring empty cells.

Syntax: =AVERAGE(range)

Example: =AVERAGE(B2:B100) calculates the average of values in B2 through B100. Use AVERAGEIF if you want to average only values meeting a condition.

3. IF — Make Decisions

IF lets you make decisions based on conditions. It returns one value if a condition is true and another if it's false.

Syntax: =IF(condition, value_if_true, value_if_false)

Example: =IF(A2>100, "High", "Low") returns "High" if A2 is greater than 100, otherwise "Low". You can nest IF statements for more complex logic.

4. VLOOKUP — Find Values in Tables

Search for a value in the first column of a table and return a value from another column.

Syntax: =VLOOKUP(lookup_value, table_array, col_index, FALSE)

Example: =VLOOKUP("Apple", A2:B100, 2, FALSE) finds "Apple" in column A and returns the matching value from column B. Always use FALSE for exact matches.

5. COUNTIF — Count Cells Meeting a Condition

Counts cells in a range that match a specific criterion.

Syntax: =COUNTIF(range, criteria)

Example: =COUNTIF(A2:A100, "Active") counts how many cells in A2:A100 contain "Active". Use COUNTIFS for multiple conditions.

6. SUMIF — Sum Cells Meeting a Condition

Adds up values in a range that meet a specified condition.

Syntax: =SUMIF(range, criteria, sum_range)

Example: =SUMIF(B2:B100, "Sales", C2:C100) adds values in column C only where column B equals "Sales".

7. CONCATENATE (or &) — Combine Text

Joins multiple text strings into one. The & operator does the same thing more concisely.

Example: =A2 & " " & B2 combines first name (A2) and last name (B2) with a space between them. Modern versions use TEXTJOIN for more flexibility.

8. LEFT, RIGHT, MID — Extract Text

These functions extract portions of text from a longer string.

LEFT extracts characters from the start: =LEFT(A2, 5) returns the first 5 characters.

RIGHT extracts from the end: =RIGHT(A2, 3) returns the last 3 characters.

MID extracts from the middle: =MID(A2, 5, 3) returns 3 characters starting at position 5.

9. TODAY and NOW — Insert Current Date

TODAY() returns today's date. NOW() returns the current date and time. Both update automatically when the spreadsheet recalculates.

Useful combo: =TODAY() - A2 calculates how many days have passed since the date in A2.

10. INDEX/MATCH — The Better Lookup

INDEX/MATCH is more flexible than VLOOKUP. It can look up values in any column and return values from any other column.

Syntax: =INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Example: =INDEX(B:B, MATCH("Apple", A:A, 0)) finds "Apple" in column A and returns the matching value from column B. The 0 means exact match.

Putting It All Together

These ten formulas form the foundation of spreadsheet mastery. Once you're comfortable with these, you can combine them for powerful results. For instance, nesting an IF inside a VLOOKUP, or using SUMIF with multiple conditions becomes natural.

The best way to learn them is by using them. Open a real spreadsheet you work with regularly and try replacing manual calculations with these formulas. Need help building a specific formula? Try our free AI formula generator — just describe what you want in plain English.

Microsoft Excel and Google Sheets are the two giants of the spreadsheet world. Both are excellent. Both can handle 95% of what most users need. But they have different strengths, and choosing the right one for your specific needs can save you hours of frustration. Let's break down the real differences.

The Quick Answer

Choose Excel if: You work with massive datasets, need advanced features like Power Pivot or VBA macros, frequently work offline, or your industry requires it (finance, accounting, engineering).

Choose Google Sheets if: You collaborate with others, want free unlimited access, work across multiple devices, or prefer cloud-based simplicity.

Pricing Reality Check

Google Sheets is completely free for personal use. You only pay if you want Google Workspace for business features ($6-18/user/month). Excel comes with Microsoft 365 starting at $6.99/month for personal or $6/user/month for business. There's also a one-time purchase option (~$140) for Excel alone.

For casual users, Google Sheets wins on price. For businesses already using Microsoft Office, Excel comes free with the package.

Performance and Limits

Excel handles much larger datasets. It can manage spreadsheets with over 1 million rows without breaking a sweat. Google Sheets has a 10 million cell limit and slows down significantly with hundreds of thousands of rows.

If you regularly work with massive datasets, Excel is genuinely better. For typical business use (under 50,000 rows), both work fine.

Collaboration Features

This is where Google Sheets shines. Real-time collaboration is built into Sheets from the ground up. Multiple people can edit the same document simultaneously, see each other's cursors, leave comments, and chat — all without conflicts.

Excel has improved with Microsoft 365 (real-time co-authoring works), but it's still not as smooth as Google Sheets. Sharing externally is also more complex with Excel.

Formulas and Functions

Both platforms have nearly identical core formulas. SUM, IF, VLOOKUP, INDEX, MATCH — all work the same way in both.

Excel has more advanced functions, especially in newer versions. Functions like LET, LAMBDA, and array formulas with dynamic arrays are more powerful in Excel.

Google Sheets has unique functions Excel doesn't have, like ARRAYFORMULA and IMPORTRANGE (which lets you pull data from other Sheets files in real-time).

Charts and Visualization

Excel's charting capabilities are more powerful and customizable. If you create complex dashboards or financial reports, you'll appreciate Excel's options.

Google Sheets has fewer chart types but covers all the basics. The defaults look modern and clean. For most everyday charts, Sheets is more than adequate.

Automation and Macros

Excel has VBA (Visual Basic for Applications) — a mature, powerful macro language that's been refined for decades. There are millions of VBA scripts available online.

Google Sheets uses Google Apps Script (JavaScript-based). It's modern and capable, with the advantage of integrating directly with other Google services. But the ecosystem is smaller than VBA.

Mobile Experience

Google Sheets has a better mobile app experience. It's faster, more intuitive, and works seamlessly across devices.

Excel's mobile app has improved significantly but feels heavier and less polished than Sheets.

Offline Capabilities

Excel is offline-first. You install it once and use it without internet forever.

Google Sheets requires internet by default but can work offline if you set it up in advance through Chrome extensions.

Industry Standards

Some industries simply expect Excel. Finance, accounting, investment banking, and engineering firms typically use Excel exclusively. Files with .xlsx extensions are universal.

Tech startups, marketing agencies, and education sectors often prefer Google Sheets for its collaboration features.

Our Honest Recommendation

If you're starting from scratch and don't have specific requirements, go with Google Sheets. It's free, easier to share, and handles everything most people need. You can always export to Excel if needed.

If you're a power user, work with massive data, need advanced features, or your work environment requires it, go with Excel. The investment pays off in capability.

The good news? Both platforms have excellent compatibility. You can open Excel files in Sheets and vice versa. Skills you learn in one transfer almost directly to the other. Need help with a formula in either platform? Try our free formula generator — it works for both Excel and Google Sheets.

If you're still reaching for your mouse every few seconds while working in Excel, you're losing hours every week. Keyboard shortcuts aren't just for power users — they're the single biggest productivity boost you can get with zero learning curve. Here are 15 shortcuts that will dramatically speed up your spreadsheet work.

Navigation Shortcuts

Ctrl + Arrow Keys

Jumps to the edge of your data in any direction. If you have 10,000 rows of data, instead of scrolling forever, just press Ctrl + Down to jump to the last row. Combine with Shift to select all data along the way.

Ctrl + Home / Ctrl + End

Ctrl + Home jumps to A1. Ctrl + End jumps to the last cell with data. Lifesaver for navigating large spreadsheets.

Ctrl + G

Opens the "Go To" dialog. Type any cell reference and jump there instantly. Even better: Ctrl + G then click "Special" to find specific types of cells (formulas, blanks, errors, etc.).

Selection Shortcuts

Ctrl + Shift + Arrow

Selects from your current cell to the edge of the data block. The fastest way to select an entire column or row of data without selecting empty cells.

Ctrl + A

Selects the current data region. Press it again to select the entire sheet. Useful for copying or formatting all your data at once.

Ctrl + Space / Shift + Space

Ctrl + Space selects the entire column. Shift + Space selects the entire row. Much faster than clicking the column or row header.

Editing Shortcuts

F2

Edit the active cell without using the mouse. The cursor goes to the end of the cell content. Game changer once you build the habit.

Ctrl + ; (semicolon)

Inserts today's date as a static value. Use Ctrl + Shift + : (colon) for the current time.

Alt + Enter

Inserts a line break within a cell. Essential for multi-line cells like addresses or notes.

F4

While editing a formula, F4 cycles through reference types: A1, $A$1, A$1, $A1. Saves countless dollar-sign typing.

Formula Shortcuts

Alt + = (equals)

Auto-sums the column or row above your selected cell. The fastest way to add a SUM formula.

Ctrl + Shift + Enter

In older Excel versions, this enters a formula as an array formula. Modern Excel doesn't need this for dynamic arrays, but it still works.

Format and Display

Ctrl + 1

Opens the Format Cells dialog. Faster than right-clicking and finding the option in the menu.

Ctrl + Shift + L

Toggles AutoFilter on and off. Instant filter dropdowns on your headers.

Ctrl + T

Converts a range to a proper Excel Table. Tables auto-expand, have built-in filtering, and make formulas more readable. Use this on every dataset.

Data Manipulation

Ctrl + D / Ctrl + R

Ctrl + D fills down from the cell above. Ctrl + R fills right from the cell to the left. Faster than dragging the fill handle for short fills.

How to Actually Learn These

Reading shortcuts won't help. Using them will. Here's the trick: pick three shortcuts you don't know, and force yourself to use them for one week. Don't allow yourself to use the mouse for those operations. After a week, they're automatic. Then pick three more.

Within a month of doing this, you'll work with Excel at twice your current speed. Your colleagues will think you're a wizard. You're just using the keyboard.

Bonus: Custom Shortcuts

You can create your own shortcuts by recording macros and assigning them to key combinations. Or use Excel's Quick Access Toolbar (top-left) to add commonly-used commands that you can trigger with Alt + 1, Alt + 2, etc.

For Google Sheets users, most shortcuts are similar. Press Ctrl + / in Google Sheets to see the full shortcut list.

Want to skip writing formulas entirely? Try our free AI formula generator — describe what you want in plain English and we'll write it for you.

A good budget tracker can transform your financial life. The problem is most templates are either too simple to be useful or so complex you give up after a week. In this guide, we'll build a personal budget tracker that's powerful but stays out of your way. The whole thing takes about 30 minutes to set up.

What This Tracker Will Do

By the end of this tutorial, you'll have a tracker that automatically:

• Categorizes your spending
• Shows total income vs total expenses
• Tracks how much you've spent in each category
• Highlights overspending in red
• Visualizes your spending patterns with charts

Step 1: Set Up the Transactions Sheet

Open a new Google Sheets document and rename it "Budget 2026" or similar. Rename the first sheet "Transactions."

Create these column headers in row 1:

• A: Date
• B: Description
• C: Category
• D: Type (Income or Expense)
• E: Amount

Make row 1 bold and freeze it (View > Freeze > 1 row).

Step 2: Create a Categories Sheet

Add a second sheet called "Categories." List your spending categories in column A. Common ones include:

• Groceries
• Rent/Mortgage
• Utilities
• Transportation
• Dining Out
• Entertainment
• Healthcare
• Shopping
• Savings
• Other

In column B next to each category, enter your monthly budget for that category.

Step 3: Add Data Validation

Go back to your Transactions sheet. Select column C (Category) and click Data > Data validation. Set criteria to "Dropdown from a range" and select your categories list. Now every time you enter a transaction, you can pick the category from a dropdown — no more typos.

Do the same for column D (Type) but with just "Income" and "Expense" as options.

Step 4: Build the Summary Sheet

Add a third sheet called "Summary." This is where the magic happens.

In cell A1 type "Total Income". In B1 enter:

=SUMIF(Transactions!D:D, "Income", Transactions!E:E)

In A2 type "Total Expenses". In B2 enter:

=SUMIF(Transactions!D:D, "Expense", Transactions!E:E)

In A3 type "Balance". In B3 enter:

=B1-B2

Step 5: Category Spending Breakdown

Below your summary, create a category breakdown. In A6 type "Category", B6 "Spent", C6 "Budget", D6 "Remaining".

Reference your categories from the Categories sheet. In A7 enter:

=Categories!A1

Drag this down to copy your category list.

In B7 (Spent), enter:

=SUMIFS(Transactions!E:E, Transactions!C:C, A7, Transactions!D:D, "Expense")

In C7 (Budget), enter:

=Categories!B1

In D7 (Remaining), enter:

=C7-B7

Drag all these formulas down for each category.

Step 6: Conditional Formatting for Overspending

Select the Remaining column. Go to Format > Conditional formatting. Set the rule: "Less than 0" with red background. Now when you overspend in any category, it lights up red automatically.

Step 7: Add a Chart

Select your category names and "Spent" amounts. Insert > Chart. Choose a pie chart or bar chart. This gives you an instant visual of where your money goes each month.

Step 8: Set Up for Multiple Months

To track multiple months, add a "Month" column to your Transactions sheet. Use this formula in column F:

=TEXT(A2, "mmm yyyy")

This automatically extracts the month and year from each transaction date. Now you can filter by month or use this in pivot tables.

Step 9: Mobile Use

Install the Google Sheets app on your phone. You can now log expenses in seconds: open the app, navigate to the Transactions sheet, add a row. Doing this immediately when you spend is the key to actually staying on budget.

Common Mistakes to Avoid

Tracking Too Many Categories

Start with 8-10 categories max. You can always add more later. Too many categories means too much friction when entering transactions.

Forgetting to Update

Set a daily 30-second habit to log expenses. Or use bank export tools to bulk-import transactions weekly.

Setting Unrealistic Budgets

Track for one month before setting budgets. Use that data to set realistic targets, then optimize from there.

Ready-Made Alternative

If building this from scratch sounds tedious, we offer a polished version in our shop with charts, category breakdowns, savings goals, and net worth tracking — all for $4.99. View the Budget Tracker if you'd rather skip the setup.

Need help with a specific budget formula? Try our free formula generator — describe what you want and we'll build the formula for you instantly.

Few things are more frustrating than spending an hour building a formula only to see #VALUE! or #REF! staring back at you. The good news? Excel error codes are actually really helpful once you understand them. Each error tells you exactly what's wrong. Here's how to read them and fix them.

#DIV/0! — Division by Zero

What it means: Your formula is trying to divide by zero or by a blank cell.

Common cause: A formula like =A2/B2 where B2 is empty or contains 0.

How to fix: Wrap with IFERROR or use IF to check first:

=IFERROR(A2/B2, 0)

=IF(B2=0, 0, A2/B2)

#N/A — Not Available

What it means: A lookup function (VLOOKUP, MATCH, INDEX) couldn't find what you were searching for.

Common cause: The lookup value doesn't exist in your data, has a typo, or has hidden spaces.

How to fix: First, verify the value actually exists. Use TRIM to remove hidden spaces:

=VLOOKUP(TRIM(A2), B:C, 2, FALSE)

If you want to handle missing values gracefully:

=IFERROR(VLOOKUP(A2, B:C, 2, FALSE), "Not found")

#NAME? — Excel Doesn't Recognize the Name

What it means: Excel doesn't know what some text in your formula means. Usually a misspelled function name.

Common cause: Typing =VLOOKP instead of =VLOOKUP, or =SUMIFF instead of =SUMIFS.

How to fix: Check spelling carefully. Also check if you're using a function from a newer Excel version that your version doesn't have.

#REF! — Invalid Cell Reference

What it means: Your formula references a cell that no longer exists.

Common cause: You deleted rows or columns that the formula was using. Or you copied a formula that referenced cells outside the new range.

How to fix: Click the cell and look at the formula. Find the #REF! reference and replace it with the correct cell. To prevent this, use absolute references with $ signs.

#VALUE! — Wrong Type of Value

What it means: Your formula expects a number but got text, or vice versa.

Common cause: Trying to add text to numbers: =A2+B2 where one cell contains "abc".

How to fix: Check that all referenced cells contain the right data type. Use VALUE() to convert text to numbers, or TEXT() the other way.

Sometimes #VALUE! is caused by hidden characters. Use CLEAN and TRIM:

=VALUE(CLEAN(TRIM(A2)))

#NUM! — Number Problem

What it means: Excel can't compute the number. Usually it's too large, too small, or impossible (like square root of a negative number).

Common cause: =SQRT(-1) or extremely large calculations.

How to fix: Check your math. For SQRT, use ABS to force positive values: =SQRT(ABS(A2)).

#NULL! — Invalid Range

What it means: You used a space between two ranges instead of a comma or colon.

Common cause: Typing =SUM(A1:A10 B1:B10) instead of =SUM(A1:A10, B1:B10).

How to fix: Add the correct separator. Use comma to add ranges, colon to define a range.

#####

What it means: The column is too narrow to display the value, or there's a negative date/time.

How to fix: Widen the column by double-clicking the column edge. If it's a date/time issue, check your formula isn't producing negative time.

The Universal Error Handler: IFERROR

If you want a single solution that handles any error, IFERROR is your friend. It returns whatever you specify when an error occurs:

=IFERROR(your_formula, "Error message or value")

Example: =IFERROR(VLOOKUP(A2, B:C, 2, FALSE), "Not found")

This converts any #N/A, #VALUE, #REF, etc. into your custom message. Use sparingly though — IFERROR can hide real problems if you wrap everything in it without thinking.

Debug Like a Pro

When a formula isn't working, use these tools to find the issue:

Evaluate Formula

In Excel, go to Formulas > Evaluate Formula. This shows you step-by-step how Excel calculates your formula. You can see exactly where it goes wrong.

F9 Key

While editing a formula, select part of it and press F9. Excel shows you the value that part evaluates to. Press Escape to exit without changing the formula.

Trace Precedents

Formulas > Trace Precedents draws arrows showing which cells feed into your formula. Great for understanding complex spreadsheets.

Prevention is Better Than Cure

Most formula errors come from a few common patterns. Avoid them:

• Always use FALSE in VLOOKUP for exact matches
• Use absolute references ($A$1) when copying formulas
• Wrap critical formulas with IFERROR
• Use TRIM to clean data before lookups
• Test formulas with a small sample before applying to thousands of rows

Got a broken formula you can't fix? Try our free Formula Fixer — paste your broken formula and we'll tell you exactly what's wrong and how to fix it.

FormulaZa is built for one simple reason: spreadsheet formulas shouldn't be hard.

What we do

Describe what you want to calculate in plain language — any of 16 supported languages — and our AI returns a working Excel or Google Sheets formula with a clear, plain-English explanation.

Three tools, one place

• Generate — turn natural language into a working formula
• Explain — paste any formula and understand exactly what it does
• Fix — paste a broken formula and get the corrected version

Built for everyone

Whether you're a student tracking grades, a small business owner managing finances, an analyst working with data, or just someone trying to organize a budget — FormulaZa removes the technical barrier between you and your spreadsheets.

Our story

FormulaZa started as a side project after spending too many hours Googling formula syntax. We thought: what if AI could just understand what you mean and write the formula for you? That's exactly what FormulaZa does. We launched in 2026 and now serve users in over 100 countries.

How we make money

FormulaZa is free for up to 50 formulas per day. We sustain the service through display advertising (Google AdSense), an optional Premium subscription for unlimited use, and a small marketplace of premium spreadsheet templates. We never sell your data.

Get in touch

Have feedback or feature ideas? Contact us — we read every message and respond within 24 hours.

Send message

Other ways to reach us

Email: hello@formulaza.com

Support: support@formulaza.com

Business: business@formulaza.com

Response times

We typically respond to all inquiries within 24 hours during weekdays. Premium subscribers get priority support with responses within 4 hours.

Frequently asked questions

Is FormulaZa really free?

Yes. You get 50 free formulas per day with no signup required. Premium ($9/month) gives you unlimited formulas and additional features.

What languages do you support?

16 languages: English, Hindi, Urdu, Arabic, Spanish, French, German, Portuguese, Turkish, Chinese, Japanese, Korean, Bengali, Tamil, Italian, and Swahili.

Do you store my formulas?

Anonymous users: formulas are stored only in your browser. Signed-up users: we store them in your account so you can access history. We never sell or share your data.

FormulaZa ("we", "us", "our") respects your privacy and is committed to protecting your personal data. This privacy policy explains how we collect, use, and safeguard your information when you visit formulaza.com.

1. Information We Collect

Information you provide:

• Email address (only when you sign up or make a purchase)
• Name (only when you sign up or contact us)
• Payment information (processed securely by PayPal/Lemon Squeezy — we never see your card details)
• Formulas you generate (to provide the service)

Automatically collected:

• IP address and approximate location (for analytics and security)
• Browser type and device information
• Pages visited and time spent
• Referring website

2. How We Use Your Information

• To provide and maintain the formula generation service
• To process your purchases and deliver digital products
• To send service-related emails (purchase confirmations, password resets)
• To send marketing emails (only if you've opted in — you can unsubscribe anytime)
• To improve our service through anonymized analytics
• To prevent fraud and abuse
• To comply with legal obligations

3. Cookies and Tracking

We use cookies and similar technologies to:

• Remember your language preference
• Track your daily formula usage count
• Keep you signed in
• Analyze site traffic (Google Analytics)
• Display personalized advertisements (Google AdSense)

You can disable cookies in your browser settings. Some features may not work properly without cookies.

4. Third-Party Services

We use the following third-party services that may collect data per their own privacy policies:

• Google AdSense — for displaying advertisements. Google may use cookies to serve ads based on your visits to our site and other sites. You can opt out of personalized advertising by visiting Google Ads Settings.
• Google Analytics — for understanding how users use our site. Data is anonymized.
• PayPal & Lemon Squeezy — for processing payments. They handle all sensitive payment information.
• Anthropic Claude API — for generating formulas. Your inputs are processed but not stored long-term by Anthropic.

5. Your Rights (GDPR / CCPA)

You have the right to:

• Access — request a copy of your personal data
• Rectification — correct inaccurate data
• Erasure — request deletion of your data
• Portability — receive your data in a portable format
• Object — object to certain processing
• Withdraw consent — opt out of marketing emails anytime

To exercise these rights, email privacy@formulaza.com.

6. Children's Privacy (COPPA)

FormulaZa is not directed at children under 13 years of age. We do not knowingly collect personal information from children under 13. If you believe we have collected such information, please contact us immediately at hello@formulaza.com and we will delete it.

7. Data Security

We implement reasonable technical and organizational measures to protect your data. However, no internet transmission is 100% secure. We cannot guarantee absolute security but commit to notifying you of any data breach as required by law.

8. Data Retention

We retain your data only as long as necessary:

• Account data: Until you delete your account
• Purchase records: 7 years (for tax/legal compliance)
• Anonymous analytics: 26 months (Google Analytics default)
• Marketing emails: Until you unsubscribe

9. International Data Transfers

FormulaZa operates globally. Your data may be transferred to and processed in countries other than your own. We use Standard Contractual Clauses and other safeguards to protect your data during such transfers.

10. Changes to This Policy

We may update this privacy policy occasionally. We'll notify you of significant changes via email or a prominent notice on our site. The "Last updated" date at the top reflects the latest revision.

11. Contact Us

For privacy-related questions:

• Email: privacy@formulaza.com
• Support: hello@formulaza.com

Welcome to FormulaZa. These Terms of Service ("Terms") govern your use of formulaza.com and our services. By accessing or using FormulaZa, you agree to be bound by these Terms. If you don't agree, please don't use our service.

1. Acceptance of Terms

By creating an account, making a purchase, or using any feature of FormulaZa, you accept these Terms. You must be at least 13 years old (or the minimum age in your country) to use FormulaZa.

2. Description of Service

FormulaZa provides AI-powered tools to generate, explain, and fix Excel and Google Sheets formulas. We also sell premium spreadsheet templates and offer a Premium subscription with additional features.

3. Free Tier and Usage Limits

Free users get 50 formulas per day. The limit resets at midnight (your local time). We reserve the right to adjust these limits to ensure fair usage and protect the service from abuse.

4. Premium Subscription

Premium subscriptions are billed monthly or annually as you choose. By subscribing, you authorize us to charge your payment method automatically until you cancel. You can cancel anytime through your account settings or by emailing support@formulaza.com.

Refunds are issued on a case-by-case basis within 14 days of purchase if you're unsatisfied. After 14 days, no refunds are issued except where required by law.

5. Digital Product Purchases

All template purchases are final and non-refundable due to the digital nature of the products. Once you receive the download link, the product is considered delivered. You may request a refund only if:

• The product file is corrupted and we cannot fix it
• You haven't downloaded the product within 7 days of purchase

6. Acceptable Use

You agree NOT to:

• Use FormulaZa for illegal activities
• Attempt to overload, hack, or disrupt our service
• Use automated bots or scripts to abuse the free tier
• Resell, redistribute, or sublicense our service without permission
• Reverse engineer or attempt to extract source code
• Misrepresent your identity or affiliation with us
• Upload malicious content or attempt to inject code
• Violate any applicable laws or regulations

7. Intellectual Property

FormulaZa branding, logo, design, and code are our property. You may not copy, modify, or distribute them without permission.

Generated formulas: Belong to you. Use them freely in your own work.

Premium templates: Licensed for personal or single-business use. You may NOT resell, redistribute, or share them publicly.

Blog content: All articles are © FormulaZa. You may share excerpts with proper attribution and link back to the original.

8. User Content

If you submit feedback, suggestions, or comments, you grant us a non-exclusive, royalty-free, worldwide license to use them to improve the service, without obligation to compensate you.

9. Account Termination

We may suspend or terminate your account if you violate these Terms or abuse the service. You may delete your account anytime by emailing hello@formulaza.com. Upon termination, your data is deleted within 30 days (except where required by law).

10. Disclaimer of Warranties

FormulaZa is provided "as is" without warranties of any kind. While we strive for accuracy, AI-generated formulas may contain errors. Always verify critical formulas before relying on them for important decisions. We are not responsible for errors, data loss, or business impact from formula usage.

11. Limitation of Liability

To the maximum extent permitted by law, FormulaZa shall not be liable for any indirect, incidental, special, consequential, or punitive damages, including but not limited to loss of profits, data, or business opportunities, arising from your use of the service.

Our total liability is limited to the amount you've paid us in the past 12 months, or $50, whichever is greater.

12. Service Availability

We aim for 99% uptime but cannot guarantee uninterrupted service. We may modify, suspend, or discontinue features with reasonable notice.

13. Indemnification

You agree to indemnify and hold harmless FormulaZa, its operators, and affiliates from any claims, damages, losses, or expenses arising from your violation of these Terms or misuse of the service.

14. Governing Law

These Terms are governed by applicable laws in our operating jurisdiction. Any disputes will be resolved through binding arbitration where permitted by law.

15. Changes to Terms

We may update these Terms occasionally. Significant changes will be communicated via email or site notice. Continued use after changes means acceptance.

16. Contact

Questions about these Terms? Email legal@formulaza.com or hello@formulaza.com.