Excel Cell Value Based on Another Cell?

How-to basics · Updated November 18, 2026

To make an Excel cell show a value based on another cell, enter a formula in the result cell. For a direct link, use =A1; for a choice based on a condition, use =IF(A1="Yes","Approved","Not approved"). The displayed result updates when the referenced cell changes, while the formula stays in place.

What it means to base one cell on another

A cell can depend on another cell in several ways. It can repeat that cell’s contents, choose between two results, calculate a value from it, or find a related item elsewhere in a table. In each case, the formula goes in the cell where you want the answer to appear, and its references point to the input cells.

For example, a task tracker might have a status in column A and a message in column B. A sales sheet might calculate a discount in column C from a purchase amount in column B. A product lookup might take an item code entered in one cell and return its description from a table. These are all examples of a result depending on another cell, but they call for different formulas.

One important distinction: a formula usually creates a live result, not a one-time copy. If the source changes, Excel recalculates the dependent result. If you need a value that will not change when the source changes, you can copy the result and paste it as a value, as explained below.

Return the contents of one cell

For a simple link, select the cell that should display the result, type an equals sign, select the source cell, and press Enter. You can also type the reference directly. For example, with the source text or number in A1 and the desired result in B1, enter =A1 in B1. B1 then displays the value from A1.

This link works with text, numbers, dates, and many other cell values. If A1 contains a date, B1 will usually display the same underlying date, although its visible appearance can differ if B1 has a different number format. To make the display look the same, apply an appropriate format to B1 from Home > Number, or use Format Cells.

A direct reference also passes along a blank-looking result if the source is empty, though Excel may display zero in some circumstances. If you want the destination to stay visually empty when the source is blank, use a conditional formula instead. With the source in A1 and the result in B1, enter =IF(A1="","",A1) in B1. This checks whether A1 is empty and returns an empty text string if it is; otherwise, it returns A1’s contents.

Use IF to choose a result

The IF function tests a condition and returns one result when the condition is true and another when it is false. Its basic structure is =IF(condition,value_if_true,value_if_false). In Excel for Microsoft 365 on Windows, commas separate the arguments in the examples here. Some regional settings use semicolons instead; if Excel rejects a formula with commas, check the list separator used by your system.

Suppose A2 contains a response and B2 should say whether it is approved. With the response in A2 and the message in B2, enter =IF(A2="Yes","Approved","Not approved") in B2. If A2 contains Yes, B2 displays Approved; if it contains anything else, B2 displays Not approved. Text values in formulas need straight quotation marks.

IF can also test numbers. With a score in A2 and a label in B2, enter =IF(A2>=70,"Pass","Review") in B2. A score of 70 returns Pass, while a score below 70 returns Review. You can replace the comparison operator with <, >, <=, >=, or <> (not equal), depending on the rule.

For calculations, the true or false result can be a number or another calculation rather than text. With a quantity in A2, a unit price in B2, and the total in C2, enter =A2*B2 in C2. If you want the total to remain blank until both inputs are supplied, enter =IF(OR(A2="",B2=""),"",A2*B2) in C2. That formula uses OR to check whether either input is blank; it returns an empty string until both contain something.

Handle more than one condition

When a result depends on several possible outcomes, you can nest IF functions or use IFS. For example, a grading rule may assign different labels to a score. With the score in A2 and the label in B2, enter =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"Below C") in B2. Excel checks the tests in order and returns the result for the first true test. The final TRUE provides a fallback for scores below 70.

IFS is available in Microsoft 365 and newer Excel versions, including Excel 2019 and later. In older versions, nested IF functions can express the same kind of decision, though the formula becomes harder to read as the number of outcomes grows. With a score in A2 and the letter grade in B2, a nested alternative is =IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","Below C"))).

For rules with many categories, consider putting the thresholds and labels in a small reference table and using a lookup formula. This keeps policy changes in the table instead of buried in a long formula. It also makes the thresholds easier for someone else to review.

Find a related value in a table

If one cell contains a key such as a product ID and you want a corresponding value from a table, use a lookup. In Microsoft 365, XLOOKUP is usually the clearest option. It searches one range and returns the corresponding item from another range. It is available in Microsoft 365 and Excel 2021 or later.

For example, suppose product IDs are in A2:A10, product names are in B2:B10, and the ID to search for is in E2. With the product name result in F2, enter =XLOOKUP(E2,A2:A10,B2:B10,"Not found") in F2. If E2 matches an ID in the first range, Excel returns the name from the same position in the second range. If there is no match, it displays Not found.

In older Excel versions without XLOOKUP, INDEX and MATCH can perform this exact-match lookup. With IDs in A2:A10, names in B2:B10, the search ID in E2, and the result in F2, enter =INDEX(B2:B10,MATCH(E2,A2:A10,0)) in F2. The zero tells MATCH to find an exact match. If no ID matches, this version returns an error; you can wrap it in IFERROR if you want a custom message. With the same ranges and search cell, enter =IFERROR(INDEX(B2:B10,MATCH(E2,A2:A10,0)),"Not found") in F2.

Check that the lookup range and return range cover the same number of rows and that the key is stored consistently. A number stored as text may fail to match a number stored as a numeric value. Extra spaces in text keys can also cause a mismatch, even when two entries look alike.

Copy a formula down a column

After creating a formula for one row, you can fill it down for additional records. If A2 contains a status and B2 contains its result formula, select B2 and drag the fill handle—the small square at the lower-right corner of the selected cell—down the column. You can also copy B2, select the destination cells, and paste. On Windows, Ctrl+D fills the selected range downward when the top cell contains the formula. On Mac, the equivalent is Command+D.

Excel normally adjusts relative references as a formula is filled. If B2 contains =IF(A2="Yes","Approved","Not approved"), filling it to B3 changes the reference to A3, so each row checks its own status. This is usually what you want in a table of records.

Sometimes a reference must stay fixed while a formula is copied. Dollar signs make a reference absolute. For example, if each row’s amount in B2:B20 is multiplied by a tax rate stored in E1, and the result goes in C2, enter =B2*$E$1 in C2 and fill down. B2 changes to B3, B4, and so on, while $E$1 remains fixed. A reference such as $E1 fixes only the column, while E$1 fixes only the row.

Why the result may look wrong

A formula can be correct while its displayed result seems unexpected. Check these common causes before rewriting it:

  • The cell shows the formula instead of the answer. The cell may be formatted as Text, or Show Formulas may be enabled. Change the format to General, re-enter the formula, and check Formulas > Show Formulas. The Windows shortcut for Show Formulas is Ctrl+`; the Mac shortcut is Control+`.
  • The result does not change after an edit. Check Formulas > Calculation Options and select Automatic. If calculation is set to Manual, Excel may not recalculate formulas immediately.
  • You see a zero for an apparently blank source. A direct reference can display zero for an empty source in some situations. Use an IF test for an empty source if the destination should appear blank.
  • The lookup returns an error or Not found. Confirm that the key exists, the search and return ranges align, and the values have matching data types. Check for leading or trailing spaces in text.
  • A copied formula points to the wrong place. Review whether a reference should be relative or locked with dollar signs before filling the formula down or across.

Excel comparisons of text are generally not case-sensitive, so a basic test for Yes normally treats yes and YES as matches. If capitalization itself must distinguish values, use a case-sensitive approach such as EXACT inside a logical test. Also note that an empty string returned by a formula is not exactly the same thing as a truly empty cell: other formulas may treat them differently.

Formula result or fixed value?

Use a formula when the destination should keep tracking the source or recalculate as inputs change. This is suitable for dashboards, totals, status labels, and lookup results. The formula remains visible in the formula bar when you select the cell, even though the worksheet displays its calculated result.

If you need to freeze the current result, copy the formula cell and paste only its value. In Excel for Windows, copy the cell, then use Home > Paste > Paste Values; the Paste Special options also include Values. On Mac, use the Paste Special options and choose Values. This replaces the formula with the displayed value, so later edits to the original source will not update it. Keep a backup or retain the formula elsewhere if you may need to restore the live link.

Conditional formatting is a different tool. It changes how a cell looks based on a rule, such as highlighting a late date, but it does not return a different text or number into that cell. If the goal is to display words such as Late or On time, use a formula. If the goal is only to color a cell based on another cell, use Home > Conditional Formatting and create a rule appropriate to the range.

Frequently Asked Questions

How do I make one Excel cell equal another?
Enter a direct reference in the destination cell. If A1 is the source and B1 is the destination, type =A1 in B1 and press Enter.

Can Excel return text based on a cell’s value?
Yes. Use IF for a simple true-or-false choice, such as returning Approved when a status cell says Yes. Use IFS or a lookup table when there are several possible categories.

How do I keep a cell blank until another cell has a value?
Use an IF formula that checks the input for an empty value and returns an empty string when it is blank. For a source in A1 and result in B1, =IF(A1="","",A1) displays nothing until A1 contains a value.

How do I copy the formula without changing its reference?
Use dollar signs to lock the row, column, or both. For example, $E$1 stays fixed when copied, while a reference without dollar signs adjusts relative to the formula’s new position.

Can I show a value from another workbook?
Yes. You can create a formula that references a cell in another workbook, but the reference includes workbook and sheet information and may depend on the source file’s location. For a simple, durable setup, keep both workbooks accessible and use Excel’s point-and-click reference creation so Excel writes the external reference syntax.

Related

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.