hi there-
I have two sheets in a workbook.
sheet 1: a form where user gets to choose from a drop down menu (breakfast, lunch, or dinner)- column A
when the user chooses one of these, i want column B to display corresponding data for type of food chosen.
sheet 2: has the following information:
breakfast lunch dinner
eggs sandwich steak
ham salad chicken
toast burger fish
i tried various methods but no success. does anybody know how to solve this?
thanks!!
-chulho
Bookmarks