I would appreciate help on what would be the correct approach to solve this,
if possible.

The purpose of the worksheet is to keep track of how much was spent from a
set of account codes. The following depicts the relevent cell from the hidden
area where the list is stored, the Header section and the main area where the
expenses are entereed.


Hidden List area:

A B
Account code Allocated
-------------------------
10 | 01-6255-400 $1200.00
11 | 01-6255-430
12 | 01-6425-200
13 | 01-6425-430 $1500.00


The header section has:

C D E
Account code Allocated Remaining
--------------------------------------------
20 | 01-6255-400 =B10 $500.00
21 | 01-6425-430 =B13 $895.00
22 | <blank
23 | <blank


The main section may have:

B C
Account Expense
| ---------------------
30 | 01-6255-400 $350.00
31 | 01-6425-430 $675.00
32 | 01-6425-430 $220.00
33 | 01-6255-400 $150.00

In the header and main area, the account code is selected from a named list
at A10:A13. There is a second lookup list defined as A10:B13

Here the $1200.00 is associated with the *-400 code and the $1500.00 with
the *-430 code.

The process would be: In C20 of the header the user selects the *.400
account code, the user enters a value for Allocated, say the $1200.00 in D20
(or maybe a dialog box). That value is stored in such a way that keeps it
associated with the *.400 account code(say at B10). If the user now selects
*.430 account code in C20, then cell D20 displays the value associated with
the *.430 code, and blank if no value is yet defined.

Essentially, I want to save a user entered value in a lookup table and
redisplay it as needed.

Thanks in advance of any suggestions.
John