Forum Discussion
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'...
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