Google Sheets Functions
13 Examples with ARRAYFORMULA in Google Sheets
Discover 13 powerful ARRAYFORMULA examples in Google Sheets to simplify formulas, automate tasks, and boost your spreadsheet skills.
Read article
Google Sheets Functions
47 articles
Google Sheets Functions
How to Count Cells with Specific Text in Google Sheets
Learn how to count cells with specific text in Google Sheets using COUNTIF, case-sensitive formulas, multiple criteria, FILTER & REGEXMATCH.
Read article
Google Sheets Functions
How to Check If a Cell is Not Empty in Google Sheets (7 Methods)
Learn how to check if a cell is not empty in Google Sheets using IF, ISBLANK, COUNTA, LEN functions, conditional formatting & Apps Script.
Read article
Google Sheets Functions
How to Transpose Rows to Columns in Google Sheets (4 Ways)
Learn how to transpose rows to columns in Google Sheets using Paste Special, the TRANSPOSE function, Apps Script, or every N rows method.
Read article
Google Sheets Functions
How To Count Highlighted Cells In Google Sheets
Learn how to count highlighted cells in Google Sheets using Apps Script, Function by Color add-on, or COUNTIF for text-based highlights.
Read article
Google Sheets Functions
How to Concatenate Text and Formula in Google Sheets
Learn how to concatenate text and formula in Google Sheets using the ampersand operator, TEXTJOIN, or CONCATENATE for flexible results.
Read article
Google Sheets Functions
How to Convert Column to Row in Google Sheets (2 Simple Ways)
Learn how to convert columns to rows in Google Sheets using the Paste Special option or the TRANSPOSE function for quick data rearrangement.
Read article
Google Sheets Functions
How to Fix Google Sheets IMPORTRANGE Not Updating Issues
Learn how to fix Google Sheets IMPORTRANGE not updating issues by reauthorizing permissions, adjusting the formula, and limiting the range.
Read article
Google Sheets Functions
Filter IMPORTRANGE with Multiple Criteria in Google Sheets
Learn how to filter IMPORTRANGE with multiple criteria in Google Sheets using FILTER, INDEX, LET, and QUERY functions.
Read article
![[Fixed] Did Not Find Value in VLOOKUP Evaluation (5 Solutions)](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-did-not-find-value-in-vlookup-evaluation-3-27d00fa7.webp)
Google Sheets Functions
[Fixed] Did Not Find Value in VLOOKUP Evaluation (5 Solutions)
Learn how to fix the “Did Not Find Value in VLOOKUP Evaluation” error in Google Sheets by correcting matches, spaces, data types, and ranges.
Read article
Google Sheets Functions
How to Do a Reverse VLOOKUP in Google Sheets (5 Examples)
Learn how to do a reverse VLOOKUP in Google Sheets using INDEX-MATCH, ARRAYFORMULA, FILTER, and QUERY for flexible and dynamic lookups.
Read article
Google Sheets Functions
Google Sheets COUNTIF to Check If a Cell Contains Text
Learn how to use COUNTIF in Google Sheets to check if a cell contains text, matches specific words, or excludes certain text entries.
Read article