Top 10 Boss Questions & How to Answer in Excel

If you’ve ever had your boss lean over your desk and say something like, “Can you just tell me…?”, you know the feeling. The clock starts ticking, eyes are on you, and your spreadsheet skills suddenly matter more than your coffee supply.

Here’s your go-to list of 10 Excel formulas that will help you answer the most common “boss questions” in seconds complete with the plain-English version of the request, the exact formula, and why it works. Download it here.

1. VLOOKUP

Boss says: “Look up product 101 and tell me the price.” Formula: =VLOOKUP(101, A2:C20, 3, FALSE)

Purpose: Search for a value in the first column of a range and return data from another column in the same row. When to use: Quick lookups in a vertical list, like finding prices, IDs, or names.

2. XLOOKUP

Boss says: “If we have sales for 101, show me — unless there are none.” Formula: =XLOOKUP(101, A2:A20, C2:C20, "No Sales")

Purpose: Modern replacement for VLOOKUP that can look up in any direction and return a custom message if nothing is found. When to use: More flexibility than VLOOKUP without worrying about column positions.

3. INDEX + MATCH

Boss says: “What is the revenue (column C) for product 101 (column A)?” Formula: =INDEX(C2:C20, MATCH(101, A2:A20, 0))

Purpose: A powerful two-part lookup where MATCH finds the row and INDEX returns the value from another column. When to use: Dynamic lookups, especially when column order might change.

4. IF

Boss says: “If they scored at least 80, show Pass; if not, show Fail.” Formula: =IF(B2>=80, "Pass", "Fail")

Purpose: Returns one value if a condition is TRUE and another if it’s FALSE. When to use: Decision-making formulas — pass/fail, yes/no, on track/off track.

5. SUMIF

Boss says: “Add the sales (column C) for the North region (column A).” Formula: =SUMIF(A2:A20, "North", C2:C20)

Purpose: Adds up numbers that meet a single condition. When to use: Region totals, category-specific sums, or conditional budgets.

6. COUNTIF

Boss says: “How many times do we have more than 100 (column B)?” Formula: =COUNTIF(B2:B20, ">100")

Purpose: Counts cells that meet a single condition. When to use: Tracking thresholds, quality checks, or performance counts.

7. FILTER

Boss says: “Show me all of the North results.” Formula: =FILTER(A2:C20, B2:B20="North", "No results")

Purpose: Returns only the rows that match specific criteria. When to use: Creating quick filtered reports without deleting or moving data (Excel 365/2021).

8. TEXTJOIN

Boss says: “I want names combined in one column with a comma between.” Formula: =TEXTJOIN(", ", TRUE, A2:A5)

Purpose: Combines multiple cells into one, with a specified separator, and can skip blanks. When to use: Creating lists from multiple entries, like names, categories, or tags.

9. PROPER

Boss says: “Capitalize the company name ‘hello world’.” Formula: =PROPER("hello world")

Purpose: Capitalizes the first letter of each word in a text string. When to use: Cleaning up inconsistent data entry in names, addresses, or titles.

10. SUM

Boss says: “Add up all the totals for me.” Formula:=SUM(C2:C20)

Purpose: Adds up all numbers in a range. When to use: Budgets, totals, or any time you need a quick sum.

Final Tip

Memorizing these 10 formulas will help you answer most of your boss’s quick questions without breaking a sweat.