Contact Formatted Cell --> Autopopulate Info into another cell.

The Bender

How can I get a cell that is formatted as a Contact List to populate a cell to the right with a phone number, email, or other static attribute when a select different contacts?

Our assigned to items can change quite frequently, and it would be great to autocomplete contact info in the next cell automatically.

Thanks.

Andrée Starå

Hi,

How many different people can there be in the assigned to?

There are a few different options.

• Add the information to a multi IF formula per each cell
• Add the information together in one cell collected from a few so-called helper columns
• Add a directory on the sheet or on another sheet that you can use to look up the information with the help of VLOOKUP or INDEX/MATCH.

Which method would you prefer?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic weekend & Happy Holidays!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD