Google Sheets Dropdown Equals: Formulas and Rules Explained

To check whether a Google Sheets dropdown equals a particular choice, compare the dropdown cell with that value in an IF formula—for example, if the dropdown is in A2, enter =IF(A2="Approved","Yes","No"). The formula returns Yes when A2 contains Approved and No for any other value.

What “dropdown equals” means in Google Sheets

A dropdown is a way to limit or guide what someone enters in a cell; after a choice is made, the cell contains a value such as Approved, In progress, or 3. To check the choice, a formula refers to that cell and compares its value with the value you care about. The dropdown itself does not need a special formula or a separate test function.

The equals sign in a formula performs the comparison. In an IF formula, the comparison is the condition: Sheets checks whether it is true, then returns one result if true and another if false. This is useful for showing a status, calculating a next step, or displaying a warning when someone selects a particular option.

For example, a project tracker might have a Status dropdown in A2 and a Follow-up column in B2. A formula in B2 could show a message only for an approved item. The value in the dropdown must match the value named in the formula; changing the option to a different label means the test will no longer be true.

Use IF to return a result for a selected value

Suppose A2 contains a dropdown with the choices Approved, Pending, and Rejected. With the status in A2, put this formula in B2; it displays Send when A2 is Approved and Hold otherwise:

=IF(A2="Approved","Send","Hold")

The parts are straightforward: A2="Approved" is the test, Send is the result when the test is true, and Hold is the result when it is false. The text values returned by a formula need quotation marks. Cell references such as A2 do not.

For more than two possible outcomes, you can use nested IF functions. With the same dropdown in A2, put this in B2; it returns the matching message for the three listed choices, and Unrecognized if the cell contains something else:

=IF(A2="Approved","Ready to send",IF(A2="Pending","Awaiting review",IF(A2="Rejected","Do not send","Unrecognized")))

Nested formulas become harder to maintain as options grow. If the dropdown has many choices, consider a lookup table that maps each choice to an outcome, then use a lookup formula instead of adding another IF for every option.

Set up the dropdown and choose the right cell

In Google Sheets in a web browser, select the cell or range where people should choose a value, then use Insert > Dropdown or Data > Data validation. Add the permitted options and save the rule. The same workflow can be used for a single cell such as A2 or for a range such as A2:A100.

When writing a comparison, point to the cell that actually contains the dropdown, not the formula cell or the dropdown’s source list. If the dropdown is in D5, the comparison should refer to D5. A correctly written formula pointed at the wrong cell can appear to work while never detecting the selected choice.

Put the dropdown in one column, such as A2:A100.
Use a separate column for the result, such as B2:B100.
Write the formula for the first row, then copy it down so each row checks its own dropdown.
Use the data-validation option to reject invalid entries if users should only select listed choices; a warning allows an unlisted entry but flags it.

Google Sheets may show dropdowns with different visual styles, such as a chip or an arrow. That appearance does not change how a formula checks the cell value. The formulas below use comma argument separators, which are common in Sheets; spreadsheet locale settings can affect which separators are accepted.

Handle blank cells and additional conditions

A basic IF formula treats a blank cell as not equal to Approved, so it returns the false result. If an empty dropdown should show a prompt rather than Hold, test for blank first. With the dropdown in A2, enter this in B2; it shows Choose a status when A2 is empty, Ready for Approved, and Not ready for another nonblank value:

=IF(A2="","Choose a status",IF(A2="Approved","Ready","Not ready"))

This order matters: the first condition handles the empty cell, and only then does the formula test for Approved. If you reverse the conditions, the formula can still work, but the blank case may be reported as the generic alternative rather than a clear prompt.

You can also combine a dropdown test with another condition. For instance, if A2 is the status and B2 is a checkbox that must be selected, put the formula in C2. It returns Ready only when the status is Approved and the checkbox is TRUE:

=IF(AND(A2="Approved",B2=TRUE),"Ready","Check both fields")

This is helpful when one selection is not enough to authorize an action. Make sure the second test reflects what the cell really contains: a checkbox returns a Boolean value, while typed words such as Yes are text and need a text comparison.

Check exact text, capitalization, and spaces

For a normal text equality test in Google Sheets, capitalization usually does not distinguish values: Approved and approved compare as equal with the equals operator. If capitalization must matter, use the EXACT function. With the dropdown in A2, enter this in B2; it returns Match only when the text has the same capitalization and characters as Approved:

=IF(EXACT(A2,"Approved"),"Match","No match")

Unexpected spaces are a more common source of trouble. A value that looks like Approved may contain a leading or trailing space, especially if it was copied from another source. Compare the formula’s text with the dropdown option itself, and inspect or clean the source values if the result is surprising. The TRIM function can remove ordinary leading, trailing, and repeated spaces from text, but it is not a universal fix for every invisible character.

Also check whether the choice is text or a number. A dropdown option containing the text “01” is not necessarily interchangeable with the number 1; text and numeric values can behave differently in comparisons. If leading zeros are meaningful, keep the choices as text and compare against the exact text label.

Highlight a dropdown choice with conditional formatting

If the goal is to color the cell rather than return a message in another cell, use conditional formatting. Select the cells to format, then choose Format > Conditional formatting. Under the rule criteria, choose Text is exactly and enter Approved to format cells containing that choice.

For a rule that depends on a formula, choose Custom formula is. For a range that begins at A2, use the formula below and set the apply-to range to A2:A100. It evaluates each row and formats the corresponding cell when its dropdown says Approved:

=A2="Approved"

Use the first cell in the selected range in the formula, and leave the row reference relative if the rule should adjust for each row. For a range beginning at A2, the reference A2 shifts to A3, A4, and so on as the rule evaluates later rows. A fixed reference such as $A$2 would make every cell in the range check only A2, which is often not what a row-by-row rule requires.

Count or total rows with a selected option

Sometimes the question is not whether one cell equals a choice, but how many rows have that choice. COUNTIF counts cells matching a criterion. With statuses in A2:A100, enter this in another cell; it returns the number of Approved entries in that range:

=COUNTIF(A2:A100,"Approved")

To add amounts only for rows with a selected status, use SUMIF. Suppose statuses are in A2:A100 and corresponding amounts are in B2:B100. Enter the formula in a summary cell; if the two Approved rows have amounts 50 and 75, it returns 125:

=SUMIF(A2:A100,"Approved",B2:B100)

Keep the status range and amount range aligned: the first row in each range should describe the same record, and both ranges should cover the same number of rows. COUNTIF and SUMIF are more concise than building a separate IF formula for every row when you need a summary.

Common reasons the comparison does not work

If a formula keeps returning the “otherwise” result, check the cell address and the spelling of the option first. A dropdown can display a value that differs subtly from the text in the formula, such as an extra space, a changed punctuation mark, or a different label. Editing a dropdown option does not automatically rewrite every formula that refers to its old wording.

Wrong reference: confirm that the formula points to the dropdown cell on the same row.
Unexpected blank: check whether the cell is empty or its formula returns an empty string, and add an explicit blank test if needed.
Text versus number: verify that a numeric-looking option is stored in the form your test expects.
Formatting confusion: number or date formatting can change how a value looks without changing its underlying value.
Copied formulas: when copying down, make sure references adjust by row; use dollar signs only when you intentionally want a fixed reference.

Google Sheets and Excel both support the basic IF comparison pattern, but their dropdown and validation menus are not identical. The menu paths above are for Sheets in a browser; Excel’s data-validation and conditional-formatting controls are found in different ribbon locations. Do not follow the Google Sheets menu instructions in Excel.

Frequently Asked Questions

What formula checks whether a dropdown equals a word?

If the dropdown is in A2, use =IF(A2="Yes","Match","No match"). It returns Match when A2 contains Yes and No match otherwise. Replace A2 and Yes with the cell and option used in your sheet.

Can a Google Sheets dropdown trigger a formula?

Yes. A formula that refers to the dropdown cell recalculates when its selected value changes. The formula can show a result, support a summary, or serve as a conditional-formatting rule.

How do I make a cell change color when a dropdown says Done?

Select the relevant cells, open Format > Conditional formatting, and create a rule for Text is exactly with Done. For a row-relative custom rule, apply it to a range beginning at A2 and use =A2="Done".

Does equals distinguish uppercase and lowercase?

Ordinary text equality in Google Sheets is generally case-insensitive. Use EXACT when capitalization must match, such as distinguishing Code from CODE.

Why does my dropdown comparison return the wrong result?

Check that the formula refers to the correct dropdown cell and that the option’s text matches, including spaces and punctuation. Also check for blank values or a text-versus-number mismatch; the displayed formatting alone does not prove that two underlying values are the same.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.