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't just do it manually.
Thanks for your help!
- Logaraj SekarSteel 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