+ Reply to Thread
Results 1 to 2 of 2

can manual entry not rewrite/overwrite a formula in a cell

  1. #1
    Registered User
    Join Date
    02-18-2011
    Location
    Iowa
    MS-Off Ver
    Office 2007
    Posts
    10

    can manual entry not rewrite/overwrite a formula in a cell

    I am making a sheet that allows a user to choose an item from a drop down. The columns are Item (drop down), Quantity, Cost (vlookup from another sheet), total cost (product(quantity,cost)).

    My question is this;

    is there a way that i can allow manual entry into the cost column that won't overwrite/rewrite the vlookup formula?.
    Last edited by bsquishy; 02-22-2011 at 05:05 AM. Reason: changed title

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: can manual entry not rewrite/overwrite a formula in a cell

    Writing a value into a cell will remove the formula.

    You could possibly have a different cell to use & an if formula, something like this

    IF(Isblank(other_cell,VLOOKUP_formula,other_cell)
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1