+ Reply to Thread
Results 1 to 4 of 4

Data Validation in Excel

  1. #1
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    126

    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
    Attached Files Attached Files
    Last edited by santanuKD; 07-27-2009 at 04:40 AM.
    Shan

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Data Validation in Excel

    See attached file.

    Regards,
    Antonio
    Attached Files Attached Files

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Data Validation in Excel

    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

  4. #4
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    126

    Re: Data Validation in Excel

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

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1