You can use vlookup for this. Have one cell as the input cell, and then vlookups below it for each piece of information you want to bring up.
In your formulas you will want to use wildcards, so you can put in part of a name.
One issue with this is of you put in a partial name, it will return the first match, and you will have to re enter more of the name.