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 t...
- Oct 10, 2023
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
OliverScheurich
Oct 10, 2023Gold 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