This is very close to what I want, but I don't want multiple lists. I want to be able to select an item from the drop down list then have a the numerical formulas in each column to the right change based on my list selection.
For example:
A1 will have a fertilizer grade of 10-34-0 which would be from a list. A2 will be where I insert a number. A3 will be =A2*0.1. A4 will be =A2*0.34.
If I chose 32-0-0 from A1, then A3 would be =A2*0.32.
Bookmarks