Forum Discussion
Natron26
Oct 10, 2023Copper Contributor
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.
- there are a few options. I just copy useful formulas to a single workbook so I know where to find them.
1 Reply
Sort By
- OliverScheurichGold Contributor
This can be done with VLOOKUP as well as with INDEX and MATCH in all Excel versions. In more recent versions of Excel you can use XLOOKUP.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support