In this article:

How to Coalesce in Google Sheets (2024 Update)

May 8, 2024

How to Coalesce in Google Sheets

The COALESCE function is used to return the first non-null value in a list of arguments. It's quite handy when you have multiple columns of data and you want to find the first non-empty value among them.

Google Sheets currently does not have a built-in COALESCE function. However, you can achieve similar functionality using the IF or IFS functions combined with the ISBLANK function in Google Sheets. Here are some simplified examples:

Using IF and ISBLANK

If you have a limited number of values to check, you can use a nested IF function combined with ISBLANK. For example, if you have three cells (A1, B1, and C1) and you want to return the first non-blank value, you can use the following formula:


google sheets coalesce

This formula checks if A1 is blank. If it is, it then checks B1. If B1 is also blank, it returns C1. Otherwise, it returns B1. If A1 is not blank, it returns A1.

Using IFS

For a slightly cleaner approach with multiple conditions, you can use the IFS function:


coalesce google sheets


The IFERROR function in Google Sheets can be used to return a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula. Here's how you might use it:

=IFERROR(A1, IFERROR(B1, "No numeric value"))

google sheets coalesce function

If there is no numeric value:

google sheets query coalesce

We hope that this article has helped you and given you a better understanding of how to coalesce in Google Sheets. If you enjoyed this article, you might also like our articles on how to use FILTER with a wildcard in Google Sheets and how to set up a GPA calculator in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->