Excel 2007 : Index Match returns 0

I am trying to get the corresponding letters in Column A Result sheet to align with the dates/letters from the table in Archive.

Formula returns 0
[=INDEX(Result!A1:A35,MATCH($A$2,Result!$B$1:$B$40,FALSE),1)]

Can anyone help please.

Thanks


Chambo


Thanks to all for the help. Problem solved.

Chambo

Hi Martin,

Why not use a Pivot? See attached. No formulas needed!

Chambo,

Give this a try in Sheet 'Result' cell B2 and then copy over and down:
=IF(SUMPRODUCT(--(Archive!$A$1:$A$33=B$1),--(Archive!$B$1:$B$33=$A2))>0,$A2,"")

How about:

Please Login or Register  to view this content.

Cheers,

Thanks. Will make a good reference for the future. Have not used pivot before but it works along with the other 2 solutions. Best Regards

Chambo

Works great and so do the other solutions. Many thanks

Chambo

Works along with the other two answers I have. Many many thanks for the valued help,


Chambo