Pyaya New Member Nov 11, 2023 #1 I want to fill the first Phones column with information from the second table, but the names of the people are not in the same order in the two tables. The actual list is very long so I can't just do it manually. Thanks for your help!
I want to fill the first Phones column with information from the second table, but the names of the people are not in the same order in the two tables. The actual list is very long so I can't just do it manually. Thanks for your help!
ETAF Active Member Nov 11, 2023 #2 use index/match or vlookup or xlookup - depending on version of excel you have assuming columns a b and c =index($C$6:$C$11, match(B2,$B$6:$B$11,0)) a sample spreadsheet would help here
use index/match or vlookup or xlookup - depending on version of excel you have assuming columns a b and c =index($C$6:$C$11, match(B2,$B$6:$B$11,0)) a sample spreadsheet would help here
