Trace cell formula error in Excel

For example, in the Table below, I get "#N/A" result in 2 of the fields that I do not expect. In Excel, how can I trace the error?

Tracing an error in Excel in very important and Excel gives you the unique error checking menu that will show you where the error comes from

excel trace cell formula error

To do it in Excel, here is the answer:

a) Click on the cell with Error and then click on "Error Checking" under "Formulas". Click on "Trace Error".

excel trace cell formula error

b) "Arrows" indicating the cells involved show up which can then be used for verification. Comparing the lookup value in I3 with the corresponding value in the table in D11, it is clear that the value in I3 is misspelt.

Fix the incorrect value in "I3". The arrows disappear automatically.

excel trace cell formula error

c) Alternatively, arrows can be removed manually even if the problem is not identified and fixed. Click on "Remove Arrows" under "Formulas". Click on "Remove Arrows".

excel trace cell formula error

d) As shown below, arrows are removed even if the error is not fixed.

excel trace cell formula error


You can find similar Excel Questions and Answer hereunder

1) How can I enter a text in a cell with subscript and superscript?

2) How do I enter a formula in a cell using VBA (using Absolute Reference)?

3) How can I clear cell after activating a routine when there is a change in value of a cell?

4) How to trace errors in Excel. How to find where an error comes from in Excel

5) How can I get input from user through a prompt and assign user's input to a cell?

6) How can I quickly navigate to a frequently used field in a voluminous worbook?

7) How can I hide Formula Bar and Headings using VBA?

8) Formula converts date to quarter and year in Excel

9) Vlookup to return multiple values in same cell in Excel

10) Formula does not calculate in Excel


Here the previous and next chapter