Forum Discussion

SS_9711's avatar
SS_9711
Copper Contributor
Apr 05, 2023

Merge columns with one common column (VLOOKUP)

Hello, I want to merge columns by using VLOOKUP function. Unfortunately, it's not working correctly as I want. In my file I have a table with name, e-mail, and country then country and e-mail.  He...
Excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Apr 05, 2023

SS_9711 

To merge columns using the VLOOKUP function, you can use the following formula in column C: =VLOOKUP(A2,F:G,2,FALSE).

This formula will search for the value in cell A2 in column F and return the corresponding value from column G.

You can then drag this formula down to fill the rest of column C with the appropriate values.

Is this what you were looking for?

  • SS_9711's avatar
    SS_9711
    Copper Contributor
    Apr 05, 2023

    NikolinoDE 

    Hi,

    I entered this formula and it still doesnt work 😞

    I've got this:

     

      • SS_9711's avatar
        SS_9711
        Copper Contributor
        Apr 05, 2023
        Sergei, thank you!
    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Apr 05, 2023

      SS_9711 

      Do you mean something like this?
      please see the example in the attached file.

      Thank you for your patience and understanding

Resources