Forum Discussion
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
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?
Do you mean something like this?
please see the example in the attached file.Thank you for your patience and understanding
