Is there a way I can Free Type in a cell that has a formula?

[tammorice]

Hi everyone

First off I have to say thank you for all the help I have received so far. I could not have got this project this far without your generous help.

I have a request (due to available space on A4 sheet) to be able to free type into a cell that has a formula.

1. User selects a (job) in A11 from a drop down list. (e.g.urban)
2. That list then triggers another list (shift) from C11 (e.g.12)
3. depending what is in C11 (set shift) it will then Vlookup the start (D11) and finish (E11) times
4. PROBLEM - not all jobs selected in A11 (e.g.jobtype6)have set shift/start and finish times. these jobs will vary in work time and need to be entered manually in the same cell that the vlookup formula is in.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]A11[/TD]
[TD="align: center"]C11[/TD]
[TD="align: center"]D11[/TD]
[TD="align: center"]E11[/TD]
[TD="align: center"]M11
[/TD]
[/TR]
[TR]
[TD="align: center"](JOB)[/TD]
[TD="align: center"](SHIFT)[/TD]
[TD="align: center"](START)[/TD]
[TD="align: center"](FINISH)[/TD]
[TD="align: center"](TOTAL)[/TD]
[/TR]
[TR]
[TD="align: center"]jobtype6[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]20:30[/TD]
[TD="align: center"]23:00[/TD]
[TD="align: center"]2:30[/TD]
[/TR]
[TR]
[TD="align: center"]Urban[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]05:40[/TD]
[TD="align: center"]13:05[/TD]
[TD="align: center"]7:25[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0:00[/TD]
[TD="align: center"]0:00[/TD]
[TD="align: center"]0:00[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 396"]
<colgroup><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 2"]=IF(C11="","0:00",CHOOSE(MATCH(A11,{"SchoolAM","SchoolPM","Urban","Route649","UrbanSat","UrbanSun","UrbanPH"},0),VLOOKUP($C11,'Route Drop Down Lists'!$B$3:$D$195,2,FALSE),VLOOKUP($C11,'Route Drop Down Lists'!$B$3:$D$195,2,FALSE),VLOOKUP($C11,'Route Drop Down Lists'!$B$3:$D$195,2,FALSE),VLOOKUP($C11,'Route Drop Down Lists'!$B$3:$D$195,2,FALSE),VLOOKUP($C11,'Route Drop Down Lists'!$B$3:$D$195,2,FALSE),VLOOKUP($C11,'Route Drop Down Lists'!$B$3:$D$195,2,FALSE),VLOOKUP($C11,'Route Drop Down Lists'!$G$75:$I$85,2,FALSE)))[/TD]
[TD="colspan: 4"][/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance.
Tam