Forum Discussion
Dropdown List with Letters, Numbers, and Formulas
=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 was trying to understand what you have written. It seems you must have many separate tables/list.
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.
- Never mind! I figured it out! Thank you so much for your help!
