Iam able to figure it out.

this is what i i have used:

=HLOOKUP(TEXT(B35,"mmm"),All!6:36,MATCH("Grand Total",All!$A$6:$A$36,0),FALSE)


Thanks craig for giving me inputs to work around it.


Appreciate all the help.