How do I lookup cells based on the cells next to it?

Copper Contributor

excel problem.png


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!

1 Reply



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