I'm not sure why you think you need a macro to do this. Using the same
features as this tutorial, you should be able to get your lookup to come
over:
http://www.officearticles.com/tutori...soft_excel.htm
This describes VLOOKUP using a table (in case the tutorial is a bit more
information than you need):
http://www.officearticles.com/excel/...soft_excel.htm
But...maybe there's something I didn't understand. I've done concatenation
with vlookup, too. You just need to create one record in your lookup table
for every possible scenario, and then have a field that concatenates them.
And your vlookup might look like =vlookup(A1&B1,mytable,3,false)

************
Anne Troy
www.OfficeArticles.com

"Warderbrad" wrote
in message ...

No, the number of items in a given day is variable based on the
avilability of moderators. I have solved the issue of compiling the
list of times by having a seperate table that uses a Concentate
statement to combine all times from the main table for refrence. So
using that work arround there is only one field for each day to pull
up.

Example of both tables

Sunday: 5-7 pm PST
Sunday: 9-11 pm PST
Monday: 4-6 pm PST

Would result to this in the second table

Sunday: 5-7 pm PST, 9-11 pm PST
Monday: 4-6 pm PST

My thought is if I could put the data from the second table into the
source field of the data validation using the list method, then the
commas would result in different items in the choosable list. However
I am having problems figuing out the syntax for the macro that would
update the validation.


--
Warderbrad
------------------------------------------------------------------------
Warderbrad's Profile:
http://www.excelforum.com/member.php...o&userid=28169
View this thread: http://www.excelforum.com/showthread...hreadid=476969