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

Jennifre

Board Regular
Joined
Jan 11, 2011
Messages
147
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
APC
1
12345T, R, F, G, V
2
67890R, T, Y, U,
3
55432T, R, F, G, V
4
5

<tbody>
</tbody>

Sheet: Sheet3

<tbody>
</tbody>

Worksheet Records
APC
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]​
55432A, B, C, D, E
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]2[/COLOR]​
67890R, T, Y, U,
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]3[/COLOR]​
12345A, 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!! :)
 
Last edited:

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Trevor_S

Well-known Member
Joined
Oct 17, 2015
Messages
614
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,972
Messages
5,621,905
Members
415,865
Latest member
pxmike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top