Excel: Match data/copy to another worksheet

Closed
Tonya - Dec 11, 2011 at 06:12 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 11, 2011 at 08:53 PM
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.

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 11, 2011 at 08:53 PM
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 .
0