Forum Discussion

Natron26's avatar
Natron26
Copper Contributor
Oct 10, 2023
Solved

Finding matching names in two lists and update the phone number for list b

I have a worksheet that has two lists

List A has a bunch of names, a lot of those names are duplicates, another column with the header phone numbers, the phone numbers column is empty 

List B has the same names without duplicates and in another column those names have a number associated with that name. 

 

I need to go to list A match the names with list B and extract all the phone numbers associated with those names into list A phone Number columns. 

Resources