Forum Discussion

pirenable's avatar
pirenable
Copper Contributor
Nov 11, 2023

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 Sekar's avatar
    Logaraj Sekar
    Steel Contributor

    pirenable 

     

    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

     

Resources