Hi, and thanks for anyone who can help here. What I want to do is have a dropdown list populated by a vlookup function and allow a couple static values in case the vlookup is applicable/accurate.
This is being used as a log file, so I want to put in a reference number, and have this cell automatically populated but changeable value if the result isn't what is needed.
As an example, if this would help. I have coded each fruit type from 1-1000. When they enter a fruit code, I want to have a dropdownlist auto-populate with the color of the fruit from a second sheet, or allow them to chose a list item if they are recording a new fruit.
Is this possible, and how can it be accomplished? Thank you very much for all the assistance.
This is being used as a log file, so I want to put in a reference number, and have this cell automatically populated but changeable value if the result isn't what is needed.
As an example, if this would help. I have coded each fruit type from 1-1000. When they enter a fruit code, I want to have a dropdownlist auto-populate with the color of the fruit from a second sheet, or allow them to chose a list item if they are recording a new fruit.
Is this possible, and how can it be accomplished? Thank you very much for all the assistance.