Hi "Bruiser",
See use of VLOOKUP you want to use False for an Exact match
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bruiser" <Bruiser@discussions.microsoft.com> wrote in message news:3F42D385-A65C-4976-BF1D-F276A1AFFCB6@microsoft.com...
> Ok so basically I'm looking for an easier way to have a school timetable show
> up.
>
> essentially, when we are given the list of offered courses we are given both
> a timeslot code (1 through 60) and the days/times this code refers to, so i
> have a worksheet set up as so
>
> Column Headers: Course Code, Fall/Winter, TimeSlot, (blank), Monday,
> Tuesday, ...Friday
>
> And I want to be able to run possibly a script/a function in the
> Monday-Friday columns that would allow me to enter any number (between 1 and
> 60) into the TimeSlot column and have the times come up automatically in the
> corresponding day columns with the proper time showing up.
>
> for example ECON 390 is time slot 45, which is monday 10:00 and wednesday
> 11:30...
>
> I want an easy (and efficient way...by efficient i mean type out the script
> once, and then just hack away these timeslots) way to be able to input "ECON
> 390" in Course Code, "Fall" from the drop down in Fall/Winter, and then put
> "45" in Time Slot...under each day the appropriate times would show up
> without having to type anything....
>
> is there any way, in Excel XP or 2003 Professional edition to do this, which
> may be LESS time consuming than actually manually typing the times in?
>
> Thanks