Hi!

This is easy in Access

This is extremely difficult in Excel! <vbg

Assume this table:

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

Is on Sheet1 with the actual data starting on row 2 extending down to row
100.

On your other sheet in cell C2 (?) enter this formula:

=VLOOKUP(B2,Sheet1!A$2:B$100,2,0)

Copy down as needed.

Biff

"Giselle" wrote in message
...
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