Originally Posted by Spencer101

Hi,

You could perhaps use a VLOOKUP as per the attached example.

You could adapt it to use INDIRECT() to update the formulas automatically rather than doing that manually, but for the small amount of 'categories' you have, the effort of setting it up once will be outweighed by the potential worksheet slowdown you will experience by using a volatile formula such as INDIRECT.

Let me know if you need more help.