Hi,

I need help with hlookup formula..

=HLOOKUP(TEXT(B35,"mmm"),All!G:T,MATCH("Grand Total",All!A:A,0),FALSE)

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Cost/Mile #N/A


Iam trying to use the above Hlookup formula under Jul(B35)

In the All Sheet , the months column starts from G(Jul) and end at S (Jun)

Iam trying to populate the Grand Total(Column A row 36) for each month.

I believe the formula fails at the highlighted text in the formula.i tested the match and text formulas individually, they work finr.


Any help appreciated .

Thanks