Automatically copying data from cells with same values

I am trying to figure out a way to get Excel to automatically copy data from multiple cells (phone number, address, etc..), when I type in a value that matches cells (name and company) from above in my spreadsheet. Does any body have any ideas?

Thanks,
Chris