Copy table column to another table column if cells are identical

[auslegung]

I have two Tables, Table1 and Table2, in a single Excel spreadsheet. Table1 is our master log, and Table2 contains only Provider Names, Contact Names, Phone Numbers, and Email Addresses. I need to compare column K from Table1 with column AT from Table2. Whenever Excel finds a perfect match, I need Excel to copy AW:AY to AB:AD. For each value in column AT, there will be several identical matches in column K.

I have search long hours for a solution, have tried to implement vlookup() and index(match()), but cannot figure either one of them. Any help would be greatly appreciated.

fyi, Table1 is almost 1500 rows long, while Table2 is not quite 80.

[AB33]

It can be done by a code. Are you familiar on how to use and run a code?

[auslegung]

I have a little bit of familiarity with coding, but almost no knowledge of VBA syntax. It needs to be

if ( K === AT ) {
AB:AD = AW:AY
}

or something to that effect. Can you translate that to VBA?

It can be done by a code. Are you familiar on how to use and run a code?

[auslegung]

Here's the solution. Replace Table45 and Table134 with any two tables, and AN, K, AC, and AQ with the appropriate cells.

Please Login or Register  to view this content.