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

	A	P	C
1​	12345	T, R, F, G, V
2​	67890	R, T, Y, U,
3​	55432	T, R, F, G, V
4​
5​

<tbody>
</tbody>

Sheet: Sheet3

<tbody>
</tbody>

Worksheet Records

	A	P	C
1​	55432
2​	12345
3​	55432
4​	23456
5​	45456

<tbody>
</tbody>

LATER:-------------------------------------------------------------

Worksheet Records, with Worksheet Tags' col P data, only on rows where their col data matches.

	[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]A[/COLOR]	[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]P[/COLOR]	[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]C[/COLOR]
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]1[/COLOR]​	55432	A, B, C, D, E
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]2[/COLOR]​	67890	R, T, Y, U,
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]3[/COLOR]​	12345	A, B, C, D, E
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]4[/COLOR]​	23456
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]5[/COLOR]​	45456

<tbody>
</tbody>

Sheet: Sheet3

<tbody>
</tbody>

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.