Excel: Data validation to show name of group.

Hi I was wondering, is there a way to use data validation list drop down, which selecting different cell drop down list values would show us a name or a result of the selected group? eg. A2 B2 C2 D2 Apple coke hair Result orange Fanta eyes So if Orange, Fanta, Hair is selected from each drop down lists the name of that group I want to show in cell D2. i know how tomake names usind sheet2 data entered. but what i don't know is what formula do i have to use in cell D2 to show the name of that selected groupo if it was to be selected from each drop down list A2, B2, C2? appreciate any help.

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of November 30, 2015.

For more resources for Microsoft Excel