Logic Validation

[brandonrlz]

Hey gang - I may be over complicating this, so I need some help in validating my thinking/logic, and to see if this is the best approach or if there is a better one.

What I'm wanting to do is have column B be nothing but a dynamic container for whatever is dropped into D3:F4. The text could change from month to month, that's why I'm taking it to a more dynamic approach.

Cell B6 and B11 however are totals that will change from month to month; therefore, they would need need to match up to the name of the client.

What I'm curious about is...would it make sense to create a drop down list of some sort or a simple text to match up to the month. That way I could easily pick the month and have it dynamically change the monthly total? Furthermore, would it be better to use a "dget" formula to capture this value, or is a match in conjunction with an "if" statement a better route?

Here's the simple layout:

Excel Workbook
	B	C	D	E	F
2	Client	*	Client	Renewal Date	Contracted PEPM
3	Client A		Client A	11/29/2011	* * * * * * *15,000,000
4	11/29/2011	*	Client B	8/25/2011	* * * * * 120,000,000
5	* * * * * * * * * * * * * * * * *15,000,000	*		*
6	*		*	Aug-11
7	*	*		Customer	Total
8	Client B	*		Client A	* * * * * * * *5,446,744
9	8/25/2012	*	*	Client B	* * * * * * *23,222,202
10	* * * * * * * * * * * * * * * *120,000,000	*	*		*
11		*	*	Sep-11
12		*	*	Customer	Total
13	*	*	*	Client A	* * * * * * * *6,535,568
14	*	*	*	Client B	24,584,283
15	*	*	*	*	*
16		*	*	Name Range
17		*	*	custAug	E8:E9
18			*	custSept	E13:E14
19	*		*	custCMBAug	F8:F9
20	*		*	custCMBSept	F13:F14
Sheet