Is your data validation pulling from a named range or a cell range. Let's say your quarters are in C1:C6
in B8
=INDEX(C1:C6, MATCH(B3,C1:C6,0)+1)
Make sense?
Update: =IF(ISERROR(INDEX(C1:C6, MATCH(B3,C1:C6,0)+1)),"", INDEX(C1:C6, MATCH(B3,C1:C6,0)+1))
Bookmarks