SOLVED

# Merge columns with one common column (VLOOKUP)

Copper Contributor

# 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.

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

# Re: Merge columns with one common column (VLOOKUP)

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?

# Re: Merge columns with one common column (VLOOKUP)

Hi,

I entered this formula and it still doesnt work :(

I've got this:

best response confirmed by SS_9711 (Copper Contributor)
Solution

# Re: Merge columns with one common column (VLOOKUP)

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

# Re: Merge columns with one common column (VLOOKUP)

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

Thank you for your patience and understanding

# Re: Merge columns with one common column (VLOOKUP)

Sergei, thank you!

# Re: Merge columns with one common column (VLOOKUP)

@SS_9711 , you are welcome

1 best response

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

# Re: Merge columns with one common column (VLOOKUP)

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