• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula does not always pick up information from source


New Member
The formula in the spread sheet seem to give you the information in some rows and colums and not others at times, yet the same formula was paste in all rows. What should i do to try and fix this problem?


Excel Ninja
Staff member

A few ideas which may help

1. Check your data, are there numbers which have been imported as text? Are there text values with extra leading, trailing or internal spaces ? Is the case of your source data consistant eg DT001 may be evaluated differently to Dt001

2. Have you used Relative & Absolute references correctly?

3. Are you using v/hlookups on unsorted data?

4. Go to an erroneous cell and use the auditing tool to trace precedents, you can keep clicking on Trace Precedents to go back several levels, make sure your logic is correct

5. With complex formulas, start in the inner level and check each layer as it is built up

6. have you used any Array formulas, check they have been entered correctly with Ctrl Enter

7. Are there anyy patterns to the errors, every 2nd row etc

Good luck