Help! - Need Formula!

[MarkAndrews]

I have the following table in my workbook

Customer Services MI Sep 06+.xls
	A	B	C	D	E
31	Reason	Sep	Oct	Nov	Dec
32	LevelofService-general	17
33	LackofCallbacks	0
34	PoorCommunication	0
35	FeeEarnerDelays	1
36	CompletionDelay	15
37	CompletionIssues	13
38	RedemptionIssue	2
39	RedStatIssues	2
40	Shortfall	1
41	Surplus	4
42	ProcessIssue	0
43	PCTIssues	0
44	TitleDeedsIssue	5
45	RegistrationIssue	1
46	DocumentIssues	5
47	DPA	1
48	Postage	0
49	CACIssues	1
50	SystemIssues	0
51	Fees	3
52	ThirdPartyIssues	0
53	Other	4
54	GrandTotal	75	0	0	0
User Entry

I need to construct a chart from this data, however - here is my dilemma

The chart I need to create, needs to show the month previous for all the ascending category's

So, from a validation cell, If the user selects September - the graph would also (automatically) show the previous months results on the same chart

Currently the data on the above table is only for 4 months, but this will grow

(There is no data on this document before September)

I am really stumped & would appreciate any help - Unfortunately i'm on a today deadline

Hope this all makes sense

TIA

Mark

 

[MarkAndrews]

From the table below

Customer Services MI Sep 06+.xls
	A	B	C	D
56			Sep
57	LevelofService-general
58	LackofCallbacks
59	PoorCommunication
60	FeeEarnerDelays
61	CompletionDelay
62	CompletionIssues
63	RedemptionIssue
64	RedStatIssues
65	Shortfall
66	Surplus
67	ProcessIssue
68	PCTIssues
69	TitleDeedsIssue
70	RegistrationIssue
71	DocumentIssues
72	DPA
73	Postage
74	CACIssues
75	SystemIssues
76	Fees
77	ThirdPartyIssues
78	Other
User Entry

C56 is a validation of Sep, Oct, Nov, Dec

C57 would be ? Index/Index Match/Hlookup? (I honestly dont know)

B57 would mirror C57, but return the month previous from the table posted previous to this 2nd post

 

[MarkAndrews]

I've got a little further, It's just the formula in this table which puzzles me now, do I use Index? Match? Hlookup?

(Results are from my first posted table)

I have no idea

Customer Services MI Sep 06+.xls
	A	B	C	D
56		September	October	Jan-06
57	LevelofService-general	#N/A	#N/A	Feb-06
58	LackofCallbacks			Mar-06
59	PoorCommunication			Apr-06
60	FeeEarnerDelays			May-06
61	CompletionDelay			Jun-06
62	CompletionIssues			Jul-06
63	RedemptionIssue			Aug-06
64	RedStatIssues			Sep-06
65	Shortfall			Oct-06
66	Surplus			Nov-06
67	ProcessIssue			Dec-06
68	PCTIssues
69	TitleDeedsIssue
70	RegistrationIssue
71	DocumentIssues
72	DPA
73	Postage
74	CACIssues
75	SystemIssues
76	Fees
77	ThirdPartyIssues
78	Other
User Entry