A1 formula =INDEX('WFA - Consumer Daily Why'!29:29,MATCH($1:$1,'WFA - Consumer Daily Why'!$10:$10))
B2 formula =INDEX('WFA - Consumer Daily Why'!30:30,MATCH($1:$1,'WFA - Consumer Daily Why'!$10:$10))
C3 formula =INDEX('WFA - Consumer Daily Why'!31:31,MATCH($1:$1,'WFA - Consumer Daily Why'!$10:$10))
D4 formula =INDEX('WFA - Consumer Daily Why'!32:32,MATCH($1:$1,'WFA - Consumer Daily Why'!$10:$10))
E5 formula =INDEX('WFA - Consumer Daily Why'!33:33,MATCH($1:$1,'WFA - Consumer Daily Why'!$10:$10))
F6 formula =INDEX('WFA - Consumer Daily Why'!34:34,MATCH($1:$1,'WFA - Consumer Daily Why'!$10:$10))
As you can see in bold, each formula pulls a different row from 29 to 34.
I know I could do =SUM(A1,B2,C3,D4,E5,F6) but I was hoping I could do a formula where I just put something like 29:34 somewhere.
Ideas?
Bookmarks