hi everyone,

I have the following formula:

=INDEX('Answer Data Month 1'!BB2:BB15000,MATCH(Analysis!A2&"-"&Analysis!B2,'Answer Data Month 1'!BA2:BA15000)*('Answer Data Month 1'!BC2:BC15000="Correct"),0)

Right now, the output is not taking the 2nd criteria "Correct" into account when displaying the answer. How can i adjust the formula to have this second criteria reflected as well?

Thanks!!