I am trying to create a lookup in one workbook to another workbook, here is
my problem:

in my other workbook, called ORANGE there are 52 sheets (one for each week).
I want to be able to enter a date 07-27-08 and be able to lookup the
coordinating sheet in workbook ORANGE called 07-27 and give me the value in
cell c2 of that sheet in workbook titled "ORANGE".

Can someone help me with this formula please.

Thank you!