Manual or Formula entry in cell.
 

Hello all,

I have a column in a spreadsheet called weekly costs. Not the majority of
the weekly costs will be manual entries. However 25% need to be picked up
from another spreadsheet. I could add an addtional colum say A and the have
in a formula in Column B that picks up from col A or does a vlookup. But I
feel that having 2 columns may cause confusion.

What I am ideally looking for is to go into a cell and have a dropdown list
that says manual or formula, clicking manual allows a manual entry, whereas
clicking formula uses the value from the vlookup formula.

Any way that this can be achieved?
--

_______________________
Naz,
London