I am looking for help on a formula in a calendar, (see attached) I have
a table with the Date, Name and Location, and what I am looking to do
is have a formula in the calendar that looks at the date on the
calendar, and the name to the far most left and return the location
that person is in on that date.
I am not very familiar with "Index" or "match" functions, but I think
that is what is needed here.
+-------------------------------------------------------------------+
|Filename: Calendar.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4092 |
+-------------------------------------------------------------------+
--
MrvinGover
------------------------------------------------------------------------
MrvinGover's Profile:
http://www.excelforum.com/member.php...fo&userid=5124
View this thread:
http://www.excelforum.com/showthread...hreadid=490253