INDEX & MATCH Function Help

[rajiv.sn78]

Hello,

I have Two sheets on the attached Workbook:

• On Summary Sheet I have Scores and data for each employee
• On Tab Report Card there are two filters and when both Values are true I need respective data from Summary Tab to be extracted on Cells B4 to B13.

I am unable to get this except for the Emp1. Please help me how I can get this for any employee selected using Index & Match or any other formula...

[Fotis1991]

Try this Array one in B5. Same for the others.

=INDEX(' Summary'!E3:E66000,MATCH('Report Card'!B2&'Report Card'!B3,' Summary'!A3:A66000&' Summary'!B3:B66000,0))

[rajiv.sn78]

I am getting value as 40553

[e.isayev]

I am getting value as 40553

Its the value of the date, change the cell format as date

[Fotis1991]

Format this as a date.

[e.isayev]

I used an arrayy formula, Mix of index, match
=INDEX(' Summary'!D2:D1000,MATCH(1,(' Summary'!A2:A1000='Report Card'!B2)*(' Summary'!B2:B1000='Report Card'!B3),0))

its for RM cell,
for the other criterias change the column names "d2:d1000" to the relevant column

[rajiv.sn78]

TY Eisayew... I did try this but for other criterias it shows #N/A

[rajiv.sn78]

Hey Sorry since its an array I missed to use Cntrl+Shift+Enter...

[rajiv.sn78]

It works Great!!! TY very much ...