Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: displaying certain information from a list

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Regina, Canada
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    how do I create a form that when I enter a clients name from a column on a spreadsheet, will fill in the rest of the information about that client in adjoining fields?
    can this be done in excel, or will it have to be done in Word?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,038
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    Consider using VLOOKUP (or DGET).

  3. #3
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    think it can be achieved with 1 basic DGET formula.

    Note: ( for this example I'm assumming your data is in sheet1 have the following headings : Name,Comment1,Comment2 )


    1- Create a Viewing Sheet to view summary data. In this example will we consider Sheet6 as the viewing sheet.

    2- in Sheet6!A1 place subject heading like "Name", sheet6!B1 = Comment1, sheet6!C1=Comment2

    3 - In Sheet6!B2 place formula =DGET(Sheet1!A:C,"Comment1",$A$1:$A$2)

    4 - in Sheet6!C2 place formula =DGET(Sheet1!A:C,"Comment2",$A$1:$A$2)


    Note: The A:C value in step 3 and 4 will need to be modified if you have more columns of source data ie. if you data is in rows A to D the change A:C acordingly.

    [ This Message was edited by: Nimrod on 2002-05-08 10:18 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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