Data Validation in Excel

Hi All,

I have a excel sheet with values correcponsing few names. I have a list for a Data Validation drop down.

How to get all the data row wise for the name selected in the drop down. KIndly guide me.

Thanks,
Santanu

Why overcomplicate formulas, using two functions when one will do? Use VLOOKUP, in J4 this formula:

=VLOOKUP(I4,C4:F9,2,0)

See the example for Data validation for how to use VLOOKUP with Data Validation

http://www.excel-it.com/excel_functions.htm

Antoka05, it might be more helpful to add some explanation to the body of the answer in future. Not all members can download files

Hey thanks a lot guys. This helped and my job lot easier.

Thanks