is it possible to set up a database and then from that database create a query in excel by typing a name in a cell in excel then it will extract from the data base into the cells below that name everything that corresponds with that name.

so basically I want to type say John in a cell in excel then all the info about john will be copied into the cells below from the database like his age, address etc. That database holds all the info about people and when you type a name in excel all that info will be copied about that person in excel.

any help would grearful

from Carl

The real question would be why? Unless I totally miss the point but I would be glad to discuss it with you. Just email me.