Need help with formula to automatically fill in Contact List from another column

Christopher Neal

Hello,

I have the following columns and sheets and I just cannot seem to figure out how to do what I need.

• Sheet 1 (Main Sheet)
  • Staff Listing (value is Text Full Name coming in from outside source)
  • All Staff (Contact List selector (assigned to))
• Sheet 2 (reference Sheet)
  • Technician Name - Contains full name
  • Email Address - contains email address

I need to fill in the All Staff contact list automatically based on the Staff Listing value.

Any help would be very much appreciated.

Christopher Neal

Got it!

My problem was I was using an email address in the other column but it needed to be a contact list just like what I was trying to Match it to

So I used:

=VLOOKUP([Staff Listing]@row, {Reference Sheet}, 2, False)

{Reference Sheet} I created a reference in the column with the Name and the contact lookup in the Directory sheet and column 2 was the contact list.

Andrée Starå

Hi @Christopher Neal

I hope you're well and safe!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Or, if you prefer, I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Christopher Neal

Got it!

My problem was I was using an email address in the other column but it needed to be a contact list just like what I was trying to Match it to

So I used:

=VLOOKUP([Staff Listing]@row, {Reference Sheet}, 2, False)

{Reference Sheet} I created a reference in the column with the Name and the contact lookup in the Directory sheet and column 2 was the contact list.

Andrée Starå

@Christopher Neal

Excellent!

Glad you got it working!