greetings

i have a table that looks like:

A B
AdNum AdName
12655 Wind*x cleaner
12899 Munchies cereal
etc

Each AdNum is unique

In another sheet is a large table showing times the ads run:

A B C
Time AdNum AdName etc...
4:35 12655
6:28 12655
12:03 12899
1.14 12655
etc etc

I'd like column C to be filled in automatically, based on the 1st table.
This is easy in Access, but I'm very new to Excel.

Help appreciated, Giselle