Using Index/Match to return a value if muliple matches are required.

[phippap]

I have a table where I want to match data to a reference. Column A may be a month, and Column B is a Name and Column C is a Value. I want to know the value of column C when month = June and Name is Smith. I know I can concatonate A and B as one way to do it, or to possibly use a Pivot table. I am wondering if there is a way to use INDEX/MATCH, where the Match reference is looking for June and Smith? Or is there some other sexy way to do this?

 

[Aladin Akyurek]

I have a table where I want to match data to a reference. Column A may be a month, and Column B is a Name and Column C is a Value. I want to know the value of column C when month = June and Name is Smith. I know I can concatonate A and B as one way to do it, or to possibly use a Pivot table. I am wondering if there is a way to use INDEX/MATCH, where the Match reference is looking for June and Smith? Or is there some other sexy way to do this?

Control+shift+enter, not just enter:

=INDEX($C$2:$C$100,MATCH(1,IF($A$2:$A$100=E2,IF($B$2:$B$100=F2,1)),0))

where E2 houses a month of interest and F2 a name of interest.