Find matching data in 2 wkshts, copying/pasting data from same-row col P to the others col P

[Jennifre]

I have two worksheets' data. Worksheet Tags. Worksheet Records.

Only Worksheet Tags has data in col P.

Worksheet Tags has only SOME of the same data in col A that Worksheet Records has in col A.

With matching data in col A, whatever I can do to copy Worksheet Tags' data in col P, inserting it
to Worksheet Records' col P (on same row where matching A col data lives), is what I need.

Changes need to happen only in Worksheet Records.

To illustrate, NOW:-----------------------------------

Worksheet Tags
[TABLE="class: cms_table_head"]
<tbody>[TR]
[TH="align: center"] [/TH]
[TH="align: center"]A[/TH]
[TH="align: center"]P[/TH]
[TH="align: center"]C[/TH]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]12345[/TD]
[TD]T, R, F, G, V[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]67890[/TD]
[TD]R, T, Y, U,[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]55432[/TD]
[TD]T, R, F, G, V[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: cms_table_grid"]
<tbody>[TR]
[TD]Sheet: Sheet3[/TD]
[/TR]
</tbody>[/TABLE]

Worksheet Records
[TABLE="class: cms_table_head"]
<tbody>[TR]
[TH="align: center"] [/TH]
[TH="align: center"]A[/TH]
[TH="align: center"]P[/TH]
[TH="align: center"]C[/TH]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]55432[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]12345[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]55432 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]23456[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]45456[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
LATER:-------------------------------------------------------------

Worksheet Records, with Worksheet Tags' col P data, only on rows where their col data matches.
[TABLE="class: cms_table_head"]
<tbody>[TR]
[TH="align: center"][/TH]
[TH="align: center"][COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]A[/COLOR][/TH]
[TH="align: center"][COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]P[/COLOR][/TH]
[TH="align: center"][COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]C[/COLOR][/TH]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]1[/COLOR]​

[/TD]
[TD]55432[/TD]
[TD]A, B, C, D, E[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]2[/COLOR]​

[/TD]
[TD]67890[/TD]
[TD]R, T, Y, U,[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]3[/COLOR]​

[/TD]
[TD]12345[/TD]
[TD]A, B, C, D, E[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]4[/COLOR]​

[/TD]
[TD]23456[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]5[/COLOR]​

[/TD]
[TD]45456[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: cms_table_grid"]
<tbody>[TR]
[TD]Sheet: Sheet3

[/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much in advance!!

 

[Trevor_S]

Re: This is easy: Find matching data in 2 wkshts, copying/pasting data from same-row col P to the others col P

In column P of your results, why are the first and third rows showing as A, B, C, D, E rather than T, R, F, G, V?

If that is a mistake, you could use a VLOOKUP formula, within an IFERROR to blank any where no match is found - like this:
=IFERROR(VLOOKUP(A1,'Worksheet Tags'!A:P,16,FALSE),"")

If the sheet isn't actually called Worksheet Tags, substitute the actual name here. Put the formula in P1 and copy down the sheet.