Merge columns with one common column (VLOOKUP)

[SS_9711]

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:

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.

[#2]

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

[#3]

@NikolinoDE 

Hi,

I entered this formula and it still doesnt work

I've got this:

[#4 · Accepted solution]

@SS_9711 

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

[#5]

@SS_9711 

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

Thank you for your patience and understanding

[#6]

Sergei, thank you!

[#7]

@SS_9711 , you are welcome