I have about 155 plans. A different entertainment expense amount is set per plan and these amounts are the same for all months. Our Personnel sheet has a plan column, but it does not allow me to create a lookup table. How can I put entertainment amount per plan in a lookup table?
Lookup tables can only be associated with Custom dimensions. However, you can do this by creating a Custom account. You can view the account in View by Plan mode so that you can easily enter values by plan. Then, you can create a calculated account on your Personnel sheet that references the Custom account.