Excel Report – You will Hate Yourself if You don’t Place your Lookup Table in a Separate Sheet

You can place your lookup table wherever you want; however, not every place is suitable for it. I have experienced a lot of frustration when I put the table in the same sheet of my report. For example, I delete columns/rows accidentally.

I will show you in this article 4 reasons to keep your table in a separate sheet.

  1. If you put the table in the same place of your lookup formula, you will need to put an instance of that table in each sheet you want to present data. This will lead to duplicates, redundant data.
  2. If you put your lookup table in the same place of your lookup formula, you will not be able to filter the table without affecting adjacent data.
  3. If you put your backend table in the same place of your lookup formula, you will not have space to update or paste more data without affecting the layout of your report
  4. If you put your table in the same place of your lookup formula, you will  not have a  focused report.

What is your style?

Have you suffered the consequences of placing the table in the same place of your Excel report?