Merge columns with one common column (VLOOKUP)

New Contributor


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. 

Here is an example of sheet:



My goal is to compare column A with F and G and fill country column (C green) just like in F and G columns.

I hope I've explained it correctly.

Thank you.


6 Replies


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?



I entered this formula and it still doesnt work

I've got this:



best response confirmed by SS_9711 (New Contributor)


VLOOKUP() work from left to right. In this case I'd use INDEX/MATCH:



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

Thank you for your patience and understanding

Sergei, thank you!

@SS_9711 , you are welcome