Assign contact to row based on reference sheet

Yann Finger

Hi there,

Is it possible to assign one or multiple contacts to a row based on a reference sheet?

Example:

Reference Sheet

Topic Staff in Charge

A John

B George

C Henry

Target sheet

Topic Staff in charge

A -> pulled from Reference sheet

A ...

B

B

I tried multiple formulas (Vlookup, JOIN(INDEX(COLLECT())), ...) but each time, the cell is populated as text instead of giving me a contact. I need this to build a smartview with the right permissions.

Thanks for your help!

Paul Newcome

You can use a formula, but it would only be able to populate one usable contact in a cell. Any additional contacts would convert the cell to text values.

To do this, try using an INDEX/MATCH or INDEX/COLLECT.