Forum Discussion
pirenable
Nov 11, 2023Copper Contributor
How do I lookup cells based on the cells next to it?
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'...
Logaraj Sekar
Nov 11, 2023Steel Contributor
VLOOKUP formula will help you.
Lets assume your data with phone number in A,B,C column and data without Phone number in D,E,F column.
In Column F, put formula as follows