displaying certain information from a list

[Tyre]

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?

 

[Aladin Akyurek]

Consider using VLOOKUP (or DGET).

 

[Nimrod]

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