Combo Box Help

[brandonrlz]

I've been watching the video's as well as reading other posts...but I'm still a little confused on how I can do this. So any insight or direction is greatly appreciated.

I'm creating a spreadsheet dashboard where I will then populate some dynamic graphs and tables based on the selection of a few different combo boxes. The tables that the combo box will pull from are dynamic and are updated from a data extract that I drop in...my problem is, I'm not familiar enough with combo boxes.

What I want to do is be able to have three combo boxes pulling in the customer name, month, and year...then based on those values have it return what it finds. My guess is that I'll have to build a formula based on the ordinal position of the combo box using a mixture of of index and match, possibly choose? That's the part that I'm not quite sure on....any help would be greatly appreciated. Here's an example of what I have.

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Jan-11			*	Feb-11			*	*
2	Customer	Profile	Totals	*	Customer	Profile	Totals	*	*
3	Bob	p001	887,830		Bob	p001	900,547	*	*
4	Bob	p002	8,087,872	*	Bob	p002	7,088,451	*	*
5	Bob	p003	572,971		Bob	p003	580,128	*	*
6	Dave	p001	1,354,891	*	Dave	p001	1,005,484	*
7	Dave	p002	22,548		Dave	p002	30,648	*	*
8	Dave	p003	554,287	*	Dave	p003	600,548	*	*
9	Charles	p001	1,115,486	*	Charles	p001	1,225,487	*	Customers
10	Charles	p002	558,431		Charles	p002	788,518	*	Bob
11	Charles	p003	584,211	*	Charles	p003	600,144	*	Dave
12	*	*	*	*	*	*	*	*	Charles
13	Combo Box Customer		Combo Box Month		Combo Box Year		*	*
14	1	*	1	*	2	*	*		Month
15	*	*	*	*		*	*	*	January
16	Return Value		*	*	*		*	*	February
17	Customer	Profile	Totals		*	*		*	*
18	Bob	p001	887,830		*	*	*	*	Year
19	Bob	p002	8,087,872	*			*	*	2010
20	Bob	p003	572,971		*	*	*		2011
Sheet

 

[brandonrlz]

Not sure why my table puts such a large gap between my text...so sorry for the formatting issue.