In Excel, you typically do this with either IF, IFS, or lookup functions depending on what you mean by “select based on content”.
Here are the most common patterns:
1) Simple condition → IF
Use this when you want to return one value or another based on a cell’s content.
=IF(A1="C", "Selected", "Not selected")
Example:
- If A1 = “C” → returns “Selected”
- Otherwise → “Not selected”
2) Multiple conditions → IFS
Use when you have several possible matches.
=IFS(
A1="A","Alpha",
A1="B","Beta",
A1="C","Charlie"
)
3) Match text to a value table → XLOOKUP (best modern method)
If you’re mapping values from a list:
| A | B |
|---|---|
| A | Alpha |
| B | Beta |
| C | Charlie |
Formula:
=XLOOKUP(A1, A:A, B:B)
4) Older Excel → VLOOKUP
=VLOOKUP(A1, A:B, 2, FALSE)
5) Conditional extraction (filtering data)
If you want to select rows based on a value:
=FILTER(A2:D100, A2:A100="C")
Quick guidance
- Single yes/no logic →
IF - Many categories →
IFS - Lookup from a table →
XLOOKUP(preferred) - Extract rows →
FILTER