Hey guys, this is a tough one (for me), please help out:
A1-A9
Su
Mo
Ma
Ra
Ju
Sa
Me
Ke
Ve
A20: Ve (I input this manually)
A21: The result that should appear here is the NEXT value from the A1-A9 table. The problem is that 'Ve' is at the end of the array above, so if I include a +1 at the end of a MATCH forumula, then it returns an error. How can I make excel start from beginning of the array (without having to manually input -8 etc) and thus show the next value which should be Su? Then I can copy this into next cell (A22) and it would then show Mo, and so on, to basically reproduce the above array but in a new order.
Right now my formula (which returns an error) for A21 is this: =INDEX($A$1:$A$9,MATCH(A20,$A$1:A9,0)+1,1)
Bookmarks