# Sheets Bootcamp - Complete Site Index ## About Sheets Bootcamp is a comprehensive, free educational resource dedicated to helping users master Google Sheets. Our content ranges from beginner-friendly tutorials to advanced techniques, covering: - Function tutorials (VLOOKUP, INDEX MATCH, QUERY, IF statements, and more) - Feature guides (conditional formatting, data validation, pivot tables, charts) - Practical use cases and real-world examples - Tips and best practices for spreadsheet efficiency Our goal is to make Google Sheets accessible to everyone, from complete beginners to power users looking to expand their skills. ## Site Structure ### Main Pages - / - Homepage with featured tutorials and category navigation - /tutorials/ - Complete tutorial index with search and filtering - /about/ - About Sheets Bootcamp - /contact/ - Contact information ### Content Categories #### VLOOKUP Tutorials (/vlookup/) The VLOOKUP pillar covers one of Google Sheets' most essential lookup functions. Topics include basic syntax, common errors, advanced techniques, and alternatives like INDEX MATCH. - VLOOKUP from Another Sheet in Google Sheets (/vlookup/undefined/) Pull data from another sheet or tab using VLOOKUP in Google Sheets. Step-by-step guide covering sheet reference syntax, naming rules, and real examples. Difficulty: beginner - VLOOKUP Approximate vs Exact Match in Google Sheets (/vlookup/undefined/) Learn the difference between VLOOKUP approximate match (TRUE) and exact match (FALSE) in Google Sheets. When to use each with step-by-step examples. Difficulty: intermediate - VLOOKUP with ARRAYFORMULA in Google Sheets (/vlookup/undefined/) Learn how to use VLOOKUP with ARRAYFORMULA in Google Sheets to fill an entire column with one formula. Step-by-step examples and error handling. Difficulty: intermediate - VLOOKUP for Beginners in Google Sheets (/vlookup/undefined/) Learn VLOOKUP in Google Sheets from scratch with this step-by-step beginner tutorial. Covers syntax, real examples, common mistakes, and practical tips. Difficulty: beginner - Case-Sensitive VLOOKUP in Google Sheets (/vlookup/undefined/) Learn how to do a case-sensitive VLOOKUP in Google Sheets using INDEX, MATCH, and EXACT. Step-by-step formula examples, common errors, and best practices. Difficulty: intermediate - How to VLOOKUP Dates in Google Sheets (/vlookup/undefined/) Learn how to VLOOKUP dates in Google Sheets. Fix date format mismatches, use DATEVALUE for text dates, and look up date ranges with step-by-step examples. Difficulty: intermediate - Fix VLOOKUP Errors in Google Sheets (/vlookup/undefined/) Fix VLOOKUP errors in Google Sheets including #N/A, #REF!, #VALUE!, and wrong results. Find the cause of each error and resolve it with formula examples. Difficulty: beginner - How to Combine VLOOKUP with IF in Google Sheets (/vlookup/undefined/) Learn how to combine VLOOKUP with IF in Google Sheets. Handle errors, add conditions to lookups, and switch ranges dynamically with examples. Difficulty: intermediate - VLOOKUP in Google Sheets: Complete Guide (/vlookup/undefined/) Learn how to use VLOOKUP in Google Sheets with step-by-step examples. Master syntax, fix common errors, and explore alternatives. Difficulty: beginner - VLOOKUP Multiple Criteria in Google Sheets (/vlookup/undefined/) Learn how to use VLOOKUP with multiple criteria in Google Sheets. Two proven methods with step-by-step examples: helper column and ARRAYFORMULA approach. Difficulty: intermediate - VLOOKUP Return Multiple Values in Google Sheets (/vlookup/undefined/) Learn how to return multiple values with VLOOKUP in Google Sheets. Three methods: FILTER function, INDEX MATCH array, and helper column approach. Difficulty: intermediate - VLOOKUP with Wildcards in Google Sheets (/vlookup/undefined/) Learn how to use VLOOKUP with wildcards in Google Sheets for partial text matching. Use asterisk and question mark wildcards with real examples. Difficulty: intermediate #### IF Statement Tutorials (/if-statements/) The IF statements pillar covers conditional logic in Google Sheets, including nested IFs, IFS function, AND/OR combinations, and error handling. - IF Statement with Checkbox in Google Sheets (/if-statements/undefined/) Learn how to use an IF statement with a checkbox in Google Sheets. Returns custom text based on checked or unchecked status with step-by-step examples. Difficulty: beginner - COUNTIF and COUNTIFS in Google Sheets (/if-statements/undefined/) Learn how to use COUNTIF and COUNTIFS in Google Sheets to count cells by condition. Covers comparison operators, wildcards, and multiple criteria examples. Difficulty: beginner - IF with AND and OR in Google Sheets (/if-statements/undefined/) Learn how to use IF with AND and OR in Google Sheets to test multiple conditions. Step-by-step examples for combining logical functions in one formula. Difficulty: intermediate - IFERROR in Google Sheets: Hide Errors Gracefully (/if-statements/undefined/) Learn how to use IFERROR in Google Sheets to replace formula errors with custom messages or blanks. Step-by-step examples with VLOOKUP and INDEX MATCH. Difficulty: beginner - Nested IF in Google Sheets (with Examples) (/if-statements/undefined/) Learn how to write nested IF statements in Google Sheets. Covers multi-tier classification, letter grades, tiered commission, and when to switch to IFS. Difficulty: intermediate - IFS Function in Google Sheets (With Examples) (/if-statements/undefined/) Learn how to use the IFS function in Google Sheets to evaluate multiple conditions without nesting. Includes real examples, IFS vs nested IF, and tips. Difficulty: intermediate - Google Sheets IF Function: Complete Guide (/if-statements/undefined/) Learn how to use the IF function in Google Sheets with step-by-step examples. Covers syntax, nested IF, IF with AND/OR, common errors, and best practices. Difficulty: beginner - SUMIF and SUMIFS in Google Sheets (/if-statements/undefined/) Learn how to use SUMIF and SUMIFS in Google Sheets to add values based on one or multiple conditions. Step-by-step examples, syntax, and common mistakes. Difficulty: beginner - SWITCH Function in Google Sheets (With Examples) (/if-statements/undefined/) Learn how to use the SWITCH function in Google Sheets to replace messy nested IFs. Includes full syntax breakdown, step-by-step examples, and error fixes. Difficulty: beginner #### QUERY Function Tutorials (/query/) The QUERY pillar covers Google Sheets' powerful QUERY function, which allows SQL-like data manipulation including SELECT, WHERE, ORDER BY, GROUP BY, and more. - QUERY GROUP BY in Google Sheets (Summarize Data) (/query/undefined/) Learn how to use QUERY GROUP BY in Google Sheets to summarize data with SUM, COUNT, AVG, MIN, and MAX. Step-by-step examples and common mistakes. Difficulty: beginner - QUERY with IMPORTRANGE in Google Sheets (/query/undefined/) Learn how to combine QUERY with IMPORTRANGE in Google Sheets to filter, sort, and summarize data from another spreadsheet. Step-by-step examples. Difficulty: intermediate - QUERY with Dates in Google Sheets (Filter, Format) (/query/undefined/) Learn how to use QUERY with dates in Google Sheets. Filter by date ranges, compare dates, format output, and avoid common date errors. Examples included. Difficulty: intermediate - QUERY LABEL in Google Sheets: Rename Headers (/query/undefined/) Learn how to use QUERY LABEL in Google Sheets to rename column headers in your output. Syntax, step-by-step examples, and common mistakes. Difficulty: beginner - Google Sheets QUERY Function: Complete Guide (/query/undefined/) Learn how to use the QUERY function in Google Sheets to filter, sort, and summarize data. Step-by-step examples with SELECT, WHERE, and GROUP BY. Difficulty: beginner - QUERY Multiple Ranges in Google Sheets (/query/undefined/) Learn how to use QUERY across multiple ranges and sheets in Google Sheets. Combine data with curly braces, IMPORTRANGE, and vertical stacking. Difficulty: intermediate - QUERY ORDER BY in Google Sheets (Sort Results) (/query/undefined/) Learn how to use QUERY ORDER BY in Google Sheets to sort results by one or multiple columns, ascending or descending. Step-by-step examples. Difficulty: beginner - QUERY SELECT in Google Sheets: Choose Columns (/query/undefined/) Learn how to use QUERY SELECT in Google Sheets to pick specific columns, reorder them, and use aggregate functions. Step-by-step examples and syntax. Difficulty: beginner - QUERY PIVOT in Google Sheets (Pivot-Style Reports) (/query/undefined/) Learn how to use QUERY PIVOT in Google Sheets to create cross-tabulated reports. Syntax, step-by-step examples, and tips for pivot-style summaries. Difficulty: intermediate - QUERY WHERE Clause in Google Sheets (/query/undefined/) Learn how to use the QUERY WHERE clause in Google Sheets to filter rows by text, numbers, dates, and multiple conditions. Examples and common mistakes. Difficulty: beginner #### Function Reference (/functions/) Individual function reference guides providing syntax, examples, and practical use cases for specific Google Sheets functions. - CONCATENATE Function in Google Sheets (/functions/undefined/) CONCATENATE joins two or more text strings into one. Learn the syntax, see examples for names and addresses, and when to use alternatives. Difficulty: beginner - COUNTIF Function in Google Sheets (/functions/undefined/) COUNTIF counts the number of cells in a range that match a condition. Learn the syntax, see examples with wildcards, and fix errors. Difficulty: beginner - DATEDIF Function in Google Sheets (/functions/undefined/) DATEDIF calculates the difference between two dates in years, months, or days. Learn the syntax, unit codes, examples, and common errors. Difficulty: intermediate - IFERROR Function in Google Sheets (/functions/undefined/) Learn how to use the IFERROR function in Google Sheets to catch errors and return a fallback value instead of displaying error messages. Difficulty: beginner - IFS Function in Google Sheets (/functions/undefined/) Learn how to use the IFS function in Google Sheets to evaluate multiple conditions and return the value for the first one that is TRUE. Difficulty: beginner - IF Function in Google Sheets (/functions/undefined/) Learn how to use the IF function in Google Sheets to return different values based on whether a condition is true or false. Difficulty: beginner - IMPORTRANGE Function in Google Sheets (/functions/undefined/) IMPORTRANGE imports a range of cells from one Google Sheets spreadsheet into another. Syntax, examples, and access permission errors. Difficulty: beginner - INDEX Function in Google Sheets (/functions/undefined/) INDEX returns the value of a cell in a range based on the row and column numbers you specify. Syntax, examples, and common errors. Difficulty: intermediate - MATCH Function in Google Sheets (/functions/undefined/) MATCH returns the relative position of a value within a one-dimensional range. Syntax, examples, and common errors explained. Difficulty: intermediate - QUERY Function in Google Sheets (/functions/undefined/) Learn how to use the QUERY function in Google Sheets to filter, sort, and summarize data using a SQL-like query language. Difficulty: intermediate - SUM Function in Google Sheets (/functions/undefined/) SUM adds numbers together from individual values, cell references, or entire ranges. Learn the syntax, examples, and common pitfalls. Difficulty: beginner - SUMIF Function in Google Sheets (/functions/undefined/) SUMIF adds values in a range that meet a condition you specify. Learn the syntax, see practical examples, and fix common errors. Difficulty: beginner - TODAY Function in Google Sheets (/functions/undefined/) TODAY returns the current date and updates automatically on each recalculation. Learn the syntax, see examples, and understand its behavior. Difficulty: beginner - VLOOKUP Function in Google Sheets (/functions/undefined/) VLOOKUP searches down the first column of a range and returns a value from any column in the same row. Syntax, examples, and errors. Difficulty: beginner - XLOOKUP Function in Google Sheets (/functions/undefined/) XLOOKUP searches a range for a key and returns a value from a result range. A more flexible replacement for VLOOKUP with built-in error handling. Difficulty: intermediate ## Content Statistics - Total published tutorials: 46 - VLOOKUP tutorials: 12 - IF Statement tutorials: 9 - QUERY tutorials: 10 - Function references: 15 ## Technical Details - Built with Astro - Content written in MDX - Mobile-responsive design - Dark mode support - Fast, static-site generation ## Contact Website: https://www.sheetsbootcamp.com Email: hello@sheetsbootcamp.com --- Generated at build time. Last updated: 2026-07-18