Hi!

I gave your file a quick look-over.....

You can use a formula "like" this:

=INDEX('Data Table'!C2:C31,MATCH(1,('Data Table'!E2:E31=A31)*('Data
Table'!B2:B31=B25),0))

Some of the "names" do not match EXACTLY:

On the Calendar sheet the "name" is "Waitlist / Misc." but on the Data Table
sheet that "name" is listed as "Misc".
You need to make them all the same in both locations.

That'll get you started. I don't have any more time tonight!

Biff

"MrvinGover" wrote
in message ...

I am looking for the answer to a similar problem. I have a calendar
format on sheet1 and there are 5 rows in each date section and those
rows correspond to peoples names which are listed in the farmost left
colum of the spreadsheet. On sheet2 there is a data table with column 1
= date column 2 = person column 3 = location.

The idea here is to return on a calendar where each person will be on a
given day by referencing a table. Any help?


+-------------------------------------------------------------------+
|Filename: MR Revenue.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4091 |
+-------------------------------------------------------------------+

--
MrvinGover
------------------------------------------------------------------------
MrvinGover's Profile:
http://www.excelforum.com/member.php...fo&userid=5124
View this thread: http://www.excelforum.com/showthread...hreadid=490074