Hi There,
I'm wanting to know if there can be a formula for the item listed in a drop-down box. If I were to enter a formula (without selecting the particular item in the drop down list with a mouse or keyboard) to select an item, say the 3rd item from the drop down list in excel, what would be the formula ? If it's even possible ?
Thank you in advance !