I'm working on a monthly budget/check registry spreadsheet.

What I want to do is have the check register link to the allowed balances in the monthly budget. I have two fields in my monthly budget for each item. A projected cost and actual cost. I want to link entries in the check registry to the actual cost of the fields in the monthly budget. I plan to use account numbers to link these fields to each other.

For example . . .

Say I buy groceries for $50. When I enter this into the check registry I enter all the necessary information along with an account number that links this transaction with my groceries actual cost field in my monthly budget spreadsheet.

Is this possible? I plan on having 20 unique IDs/Account numbers.