Combine two tables

[Ashleyyy]

Hi,
I know the vlookup formula will come in handy.

Could someone please write me a code that matches the values of the cells in 2 columns in 2 separate tables then generates a third table? If a value appears in the first table but not in the second I would like in in the third table with a blank for the missing value. If table 2 has a value that table 1 does not I would not like to see it in the third table. An example of what I am looking for is in the excel sheet attached.

Please help.

Thank you.


Regards,
Ashley

[nilem]

Hi, Ashley. Try it

Please Login or Register  to view this content.

[Ashleyyy]

Dear Nilem,
Thank you!! I will work on this.

Regards,
Ashley

[Ashleyyy]

..........

[Ashleyyy]

Hi Nilam,
I'm so so sorry but my example is wrong. Table 1 may have repeats of a value. I'd like for repeats of a value in table 1 to generate the same output in table 3. I tried with the current code this does not happen. I've attached an updated example for this.

I'd appreciate it if you could modify the code to reflect this, I'm sorry I overlooked this earlier.

Thank you.


Regards,
Ashley

[nilem]

Let's swap the "x" and "y"

Please Login or Register  to view this content.

[Ashleyyy]

Thanks Nilam!!