in O2
=INDEX($A$2:$A$5,INT((ROWS($1:1)-1)/12)+1)
in P2
=INDEX($B$2:$M$5,MATCH($S2,$A$2:$A$5),MOD(ROWS($1:1)-1,12)+1)
in O2
=INDEX($A$2:$A$5,INT((ROWS($1:1)-1)/12)+1)
in P2
=INDEX($B$2:$M$5,MATCH($S2,$A$2:$A$5),MOD(ROWS($1:1)-1,12)+1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks