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
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
Last edited by santanuKD; 07-27-2009 at 04:40 AM.
Shan
See attached file.
Regards,
Antonio
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
Last edited by royUK; 07-27-2009 at 03:07 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hey thanks a lot guys. This helped and my job lot easier.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks