lookup upon variable

[sna]

Hi there,

I got another issue for looking data base on month variable.

I want to return all data's base upon month choosing.

I colour the results

TY

[norkaz]

Hi there,

I got another issue for looking data base on month variable.

I want to return all data's base upon month choosing.

I colour the results

TY

Hi Guy,

Please provide the Excel attached.

Norkaz

[sna]

sorry

here is an attachment

TY

[norkaz]

...

K13

=SUM(INDEX((LOOKUP(COLUMN($B$4:$V$4),COLUMN($B$4:$V$4)/($B$4:$V$4<>""))-COLUMN($B$4)+1=MATCH($K$11,$B$4:$V$4,0))*$B6:$V6*(K$12=$B$5:$V$5),0))

Norkaz

[sna]

more solutions, would be helpful

[Supachok]

K13
[font]revision [/font]

=OFFSET(INDEX($B$5:$U$5,MATCH($J$11,$B$4:$U$4,0)),ROW(A1),COLUMN(A1:A1)-1)

Array formula {}

[norkaz]

...

K13

=SUM(INDEX((LOOKUP(COLUMN($B$4:$V$4),COLUMN($B$4:$V$4)/($B$4:$V$4<>""),$B$4:$V$4)=$K$11)*(K$12=$B$5:$V$5)*$B6:$V6,0))

Norkaz

[sna]

Ty , really appreciate