hlookup formula .

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

still getting an error

it is evaluating as =HLOOKUP("Jul",All!$7:$18,36,False)

Still error at the same position

It's all Strings.... "Jul","Aug".....


but the Data in All Sheet is a Pivot Table.


Thanks,

Hi Craig,

Tried

The GrandTotal (A36)... and the Jul(G6), the data values starts at (G7 to R36--- table array) iam trying to pull up the Grandtotal for the month of Jul located at G36.


Thank you so much for helping me out.


Hope iam clear.

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.