The Ultimate Excel, Google Sheets & VBA Formula Library
Free guides, syntax references, real-world examples, and best practices — plus AI-powered formula generation when you need something custom.
- Formula Guides
- 6+
- Examples
- 10+
- Updated
- Weekly
- Last update
- Jul 18
Browse Excel & Sheets formula guides
Showing 6 of 6 guides.
- Intermediate
Excel • Lookup
XLOOKUP Function in Excel
XLOOKUP searches a range or array and returns the corresponding value from a second range. It replaces VLOOKUP and HLOOKUP with a simpler, more flexible syntax.
2 min read2 examplesUpdated Jul 18, 2026Read Guide - Intermediate
Excel • Logical
SUMIFS Function in Excel
SUMIFS adds the cells in a range that meet multiple criteria. It is the go-to function for conditional aggregation across one or more columns.
2 min read1 exampleUpdated Feb 2, 2026Read Guide - Beginner
Excel • Lookup
VLOOKUP Function in Excel
VLOOKUP looks for a value in the first column of a range and returns a value in the same row from another column. Still widely used, though XLOOKUP is preferred for new work.
2 min read1 exampleUpdated Jan 20, 2026Read Guide - Advanced
Google Sheets • Advanced
QUERY Function in Google Sheets
QUERY runs a Google Visualization API query on a range of data — a SQL-like language that filters, sorts, aggregates, and pivots directly inside a sheet.
2 min read2 examplesUpdated Mar 10, 2026Read Guide - Intermediate
Excel • Arrays
FILTER Function in Excel & Google Sheets
FILTER returns the rows or columns that match one or more conditions. It is a dynamic array function that spills results automatically, replacing manual copy-paste or helper columns.
2 min read2 examplesUpdated Jul 18, 2026Read Guide - Advanced
Excel • Lookup
INDEX MATCH Combination in Excel
INDEX and MATCH are two functions that work together to look up values in any direction. Unlike VLOOKUP, INDEX/MATCH can search left or right, and it is more flexible and robust.
2 min read2 examplesUpdated Jul 18, 2026Read Guide
Popular right now
Data-driven — connects to real analytics as it becomes available.
Trending this week
Most viewed
You may also like
Explore related learning tracks.
Excel Formulas
Lookup, logical, text, date, financial, and dynamic-array functions in Microsoft Excel.
- 1000+ Formulas
- Beginner → Advanced
- Free & Pro Guides
Google Sheets
QUERY, ARRAYFORMULA, IMPORTRANGE and Sheets-only functions.
- 500+ Formulas
- Apps Script tutorials
- Free & Pro Guides
- Annual
VBA Tutorials
Automate spreadsheets with subroutines, event handlers, and macros.
- 250+ Tutorials
- 50+ Projects
- Annual Exclusive Packs
- Annual
Excel Templates
Copy-and-go workbooks for finance, ops, HR, sales, and analytics.
- 500+ Templates
- Monthly Releases
- Annual VIP Packs
Can't find the exact formula you need?
Generate a custom Excel or Google Sheets formula instantly using AI. Describe what you need in plain English — get a ready-to-paste formula in seconds.
Generate Formula NowJoin the XLFormula AI Insider Club
Get weekly Excel formulas, Google Sheets tips, VBA tutorials, new template releases, productivity tips, and exclusive AI features delivered straight to your inbox.
Free forever. No spam. Unsubscribe anytime.