index match....help!

[bluepenink]

Hello

Im trying to show data for individuals from a drop down list, and its based on a few criterias

Im trying to make my index, match formula lookup
a) look the year (i.e. 2010, 2011); person's name, revenue report to use.

the part im struggling with is, how can i reference the person's name to be a match source?

here is my formula:

=INDEX(Table9,MATCH($D$7,INDEX(Table9,0,1),0)+1,MATCH($C12,INDEX(Table9,1,0),0))

it works perfectly, but im not sure how i can make it reference the employee name

D7 = year selection from drop down (2010, 2011)
C12 = period i want data to show for (which week i want show i,e. P1W1, P1W2 etc)

that portions works fine and provides me with correct info., however I have the person's name in cell D6, not sure how i can incorporate that into the formula?

the reason why i use +1 is bc the data skips a line, thx you so much!

 

[jbeaucaire]

EXCEL JEANIE
Use Excel Jeanie to post up some visible examples of the data you're referring to, and perhaps a mockup of the desired results you have in mind.

 

[bluepenink]

Hello

Thxs, however I was not able to find much info., on her site relating to my topic.

this is what my attemt was, however didnt have much luck got an error when i inserted to search by name or D6.

=INDEX(Table9,MATCH($D7,INDEX(Table9,0,1),MATCH($D$6,INDEX(Table9,0,1)+1,MATCH(C$11,INDEX(Table9,1,0), 0))))

 

[jbeaucaire]

Excel Jeanie is an Excel tool you should have downloaded and installed into your Excel. It allows you to select a range of cells, then select the new menu option that installed on your menu bar to create a "clipboard" picture of HTML that you could then paste into a forum message here and actually see the results, like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
2	SHOW YEAR	Non-Returning Attendees	Attended 8 shows	Attended 7 shows	Attended 6 shows	Attended5 shows	Attended4 shows	Attended 3 shows	Attended 2 shows	1st Time Attendees
3	2004	2	-	-	-	-	-	-	-	53
4	2005	0	-	-	-	-	-	-	19	31
5	2006	5	-	-	-	-	-	11	17	59
6	2007	0	-	-	-	-	8	16	44	0
7	2008	0	-	-	-	7	10	27	39	0
8	2009	1	-	-	5	7	15	21	38	1
9	2010	0	-	4	6	10	12	24	42	0
10	2011	0	3	5	8	10	17	32	55	0
11		1	8	7	6	5	4	3	2
Show Statistics