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 05:40 AM.
Santanu
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 04:07 AM.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
Hey thanks a lot guys. This helped and my job lot easier.
Thanks
Santanu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks