Why Does VLOOKUP Return #N/A When Value Exists? (Examples)
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
Can you use noncontiguous ranges in the data parameter in a QUERY() function? Yes, you can. Google Sheet’s QUERY() function permits the ability to use noncontiguous ranges, but they must …
Merged cells are a great way to span content over multiple cells, and you can easily remove a single merged cell with one click by clicking on the merge cell …
There will come a time when using Google Sheets where you will be checking the value of a cell against multiple criteria, which one is the best to use? There …
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. …
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only …
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is …
Recently, I had an issue where I needed to calculate the age of a person at specific dates throughout the year. Using a Google Sheet, I thought I could simply …
Very similar to our previous article on how to make a header row in Google Sheets, in this article we’ll show how you can lock a column in Google Sheets. …
I was recently working with a lot data on my Google Sheets spreadsheet and as I scrolled down the page the information from the top rows moved off and I …
In a previous post, I explored how to ignore blank cells when using the QUERY function in Google Sheets, which had its own distinct way of removing blank cells from …
Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real quick!
How do you find the difference between two dates in Google Sheets? Do you just subtract two dates? Or is there a handy formula you can use to better calculate the difference. In most spreadsheets there is a handy little function called DATEDIF (date dif) which can do more than just find the difference in days between two dates.
The only limitation with the ARRAY_CONSTRAIN function is it fetches from the upper-leftmost corner of the range. Here we combine the QUERY and TRANSPOSE functions to flip a range, so the ARRAY_CONSTRAIN formula can fetch from the lower-rightmost corner of a range.
When using the QUERY function in Google Sheets how can we ignore certain rows based on the criteria of some cells being blank?
How do you merge multiple columns into one column in Google Sheets using the QUERY function? In this 4 simple step-by-step process we share the formula, and teach you along the way on how component within the function works by providing commentary and photos at each change.
Merge multi-columned data to one column before expanding it out into a different columned layout using the QUERY and ARRAYFORMULA functions in Google Sheets.
How do you calculate the sum of values across columns when the length of the range of those columns is dynamic? Use the INDEX function, as demonstrated in this post.
Continuing to advance my feature previously on combining two columns into one unique column, here we combine multiple columns into one unique sorted column in Google Sheets.
If you need to join two columns of unknown height together then follow this step-by-step illustrated guide.