Forum Discussion
Solved
Dropdown List with Letters, Numbers, and Formulas
Ok, so this is a little hard to explain. So I've created a dropdown list that will contain the letters C, G, S, L, and E to represent types of drawings. (i.e., G is a general drawing). Each drawi...
=INDEX($F$2:$O$35,COUNTIF($A$2:A2,A2),MATCH($A2,$F$1:$O$1,0))You can try this formula in cell B2 and copy it down.
I'm not the best at explaining things when it comes to Excel lol. Here's an updated version of what I have. The 'Code' column (column b) just doesn't go down to the next code. i.e., A2="general" so B2=G-001; when A12="general", B12 SHOULD equal G-002, but instead it shows G-001 again. Hopefully, this makes more sense!
A quick note about my picture. Columns F to O are the drawing codes for each drawing type. Columns F and H to O (so not column G) go up to 1 below the next column's first number. i.e., profile is C-110 to C-199, and section is C-200 to C-299. (If you need more clarification let me know!)
=INDEX($F$2:$O$35,COUNTIF($A$2:A2,A2),MATCH($A2,$F$1:$O$1,0))You can try this formula in cell B2 and copy it down.