Excel: Match data/copy to another worksheet [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

Can someone help me with this please? : )

I'm using 2 worksheets:
On 'Tab A' I have:
Column A Column B
Notification Product Event #
30001234 700000001
30001235 700000002
30001236 700000003
30001237 700000004
30001238 700000005
On 'Tab B' I have:
Column A Column B Column C
Notif.date Notification PE#
10/01/2011 30001238
10/03/2011 30001236
10/03/2011 30001237
10/03/2011 30001235
10/03/2011 30001234

I want to see if the notification#s on Tab A matches what's on Tab B, if so, I want to take the associated Product Event# next to that notification and place it on Tab B in the PE# field (Column C). I'm stuck...help!!! I'd appreciate it. Thank you so much in advance.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
in second sheet in C2 type this formula

=VLOOKUP(B2,Sheet1!$A$1:$B$100,2,0)
and copy it down

if it is more than 100 rows change .

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!