Index and Multiple Match Help

[cpferny]

Hey There!

I am trying to find the number that shows as January and a specific department. I have all months in a chart and the name of the department in the top left. The formula worked for the first department but it is not working for the next department. AE:AE in the formula is looking up the column where I need the number to come from. that same number will show multiple times if I say January and Dept. It is the same number for all agents, so I just need it to show once for the whole dept, not by agent.

{=INDEX('Reporting Raw'!$AE:$AE,MATCH("Name of Dept",'Reporting Raw'!$I:$I,0)*MATCH("January",'Reporting Raw'!$A:$A,0))}

 

[kang23]

can you post a screen shot or something?
I'm not following

 

[cpferny]

Sorry, how do I do that? It will not let me paste an image and I do not know how to get the URL to put it in here.

 

[cpferny]

 

[AhoyNC]

Try this to post a small sample:
Put a boarder around around a small sample and then use Copy/Paste to put in forum.