In colunm A, row 2 I have the W/C dates that populate down throghout that colunm.
In colonm B, I have Duty Numbers which also populates down.(It is set up so that I can just enter the first date & duty number and it populates down)
In colunms C,D,E,F and so on, I have a vlookup formula that looks at the duty number colunm and inserts the relavent duty time for each day ( the days are across the top row 1) what I want to happen is: that if christmas day falls on say Tuesday, I want the cell with the vlookup formula in to say "Christmas day" is this possible. ( it is not possible to just write Chistmas day in the cell because it changes position in the table as I change the date and duty number at the top of colonms A & B).. Hope iv'e explained this clearly, can any one help, any suggestions are welcome.
In colonm B, I have Duty Numbers which also populates down.(It is set up so that I can just enter the first date & duty number and it populates down)
In colunms C,D,E,F and so on, I have a vlookup formula that looks at the duty number colunm and inserts the relavent duty time for each day ( the days are across the top row 1) what I want to happen is: that if christmas day falls on say Tuesday, I want the cell with the vlookup formula in to say "Christmas day" is this possible. ( it is not possible to just write Chistmas day in the cell because it changes position in the table as I change the date and duty number at the top of colonms A & B).. Hope iv'e explained this clearly, can any one help, any suggestions are welcome.