Drop down menu + change List dynamically + Excel

[ravi]

Hi,

The format of the sample raw data is as follow.
Name Age Income
Allen 23 334
Paul 45 234
Stephen 67 32

I am trying to create a drop down menu which has the list of the
names(Allen,
Paul,stephen). I can create a drop down menu using the combo box or
using Data Validation.When i select one name in the drop down menu all
the fields relevant to that selection should be visible. Let us assume
i select 'Allen' from the drop down menu then i should get the Allen,
23 , 334 . Is there any way we can do this in Excel without using VBA.

Thanks for your help,
Regards,
Ravi

 

[fabriXio]

Is there any way we can do this in Excel without using VBA.

Use VLOOKUP function.

See you.