Find date in list, return static cell value

[kasper]

What I would like to do is compare a calendar like chart against a list of weekend dates and return the word "Weekend" in the chart for the dates that match.
I have already done a vlookup for a different worksheet that returns a W.
Excel 2010

	C	D	E
3		January	February
4	1
5	2

<tbody>
</tbody>

clean - COPY do not write on​

Worksheet Formulas Cell Formula D4 =IFERROR(VLOOKUP(D$3&$C4,INDIRECT($Q$3),2,0),IFERROR(VLOOKUP(D$3&$C4,Miscellaneous,2,0),"")) <tbody> </tbody>

<tbody>
</tbody>

Workbook Defined Names Name Refers To Miscellaneous ='2015'!$Y$23:$Z$27 <tbody> </tbody>

<tbody>
</tbody>

Excel 2010

	B	C	D	E	F
14	Weekend		03-Jan-15	January3	W
15			04-Jan-15	January4	W
16			10-Jan-15	January10	W
17			11-Jan-15	January11	W
18			17-Jan-15	January17	W

<tbody>
</tbody>

holidays

​

Instead of altering my existing table D:F by adding the word "Weekend", I was hoping to simply return the single value from cell $B$14 every time a date in the calendar matches a date in E. Is there a formula that can do that?

 

[jackhandey]

Hooray! My pleasure.