Please see attached as an example. I am looking for a formula that looks at what is selected in the drop down cell (B3) and will pull all of the elements of the description on sheet 2. For example, if Peach is selected on sheet 1 then two cells in column C would show Fuzzy and Pit. If Apple is selected, then 3 cells to the right of the drop down in column C would show Red, Sweet and Cooking. If a VB code is required that works too.