Show a certain cell depending on data from a drop down menu.

Hi,

This is my first post so hopefuly someone will be able to help!

This is a little hard to explain so i hope i make it clear.

I have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.

I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.

I can imagine that this is hard to picture so i have attached the file as well.

Thank you!