is there any way to auto populate user dept, name etc with email address into Excel from Outlook?

hi   I like to check if there's any way to auto populate using email address to pick up the user name, department, contact etc from Outlook addresses book?   I only have the email addresses.. nee...