I have a dependent dropdown list. Based on the value in A1, the list in B2 is then generated. When I click on the down arrow on the B2 cell, my values start with the second value in the table data and ends with the first value. Such as 2, 3, 4, 5, 1. Or I tried with alpha data and still get: B, C, D, E, A. Here is the formula I am using: OFFSET(Details!$B$1,MATCH($B$2,Details!$A:$A,0),0,COUNTIF(Details!$A:$A,$B$2),1). Any suggestions? Thanks in advance.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!