SOLVED

Merge columns with one common column (VLOOKUP)

Copper Contributor

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. 

Here is an example of sheet:

SS_9711_2-1680679921390.png

 

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

@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?

@NikolinoDE 

Hi,

I entered this formula and it still doesnt work :(

I've got this:

SS_9711_0-1680682231215.png

 

best response confirmed by SS_9711 (Copper Contributor)
Solution

@SS_9711 

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

image.png

@SS_9711 

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

1 best response

Accepted Solutions
best response confirmed by SS_9711 (Copper Contributor)
Solution

@SS_9711 

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

image.png

View solution in original post