Hello everyone
I’m struggling with a index match, lookup formula, here’s what I ‘m trying to do
I have a table range $F$5:$EO$36
Column F6:F36 represents dates
From G5:EO5 is the header row with location names
Range G6:EO36 are sum totals
In Cell AI1 I’m trying to right a lookup formula that will match the date reference in $A$3 to the matching date in range $F$5:$EO$36 with the location name in $B$1 that matches G5:EO5 and provide the sum totals G6:EO36
Any help will be greatly appreciated
Thanks everyone
I’m struggling with a index match, lookup formula, here’s what I ‘m trying to do
I have a table range $F$5:$EO$36
Column F6:F36 represents dates
From G5:EO5 is the header row with location names
Range G6:EO36 are sum totals
In Cell AI1 I’m trying to right a lookup formula that will match the date reference in $A$3 to the matching date in range $F$5:$EO$36 with the location name in $B$1 that matches G5:EO5 and provide the sum totals G6:EO36
Any help will be greatly appreciated
Thanks everyone