Results 1 to 4 of 4

Thread: VLOOKUP code deleted if user types in cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,478
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default VLOOKUP code deleted if user types in cell

    Hi,
    I have this code in various cells,obvioulsy each with a different cell reference.

    Code:
    =IFERROR(VLOOKUP($B12,INDIRECT("INFO!$CV$2:$DB$"&COUNTA(INFO!$CV:$CV)),5,FALSE),"")
    I select a customers name in cell B then VLOOKUP populates cells C D & E
    Now column D refers to how much the customer has paid me.
    9/10 the fee is always the same but today it was different.

    So if like normal i select a customers name & the cell in column D has 30 applied todays fee was 50
    If i manually type 50 into the cell then the VLOOKUP code is deleted.

    Is there a workaround for this please so the VLOOKUP isnt deleted.
    Or what can you advise

    Thanks
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

  2. #2
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,258
    Post Thanks / Like
    Mentioned
    91 Post(s)
    Tagged
    5 Thread(s)

    Default Re: VLOOKUP code deleted if user types in cell

    When you type anything into a cell that contains a formula, the formula will always be over-written by the value.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,478
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VLOOKUP code deleted if user types in cell

    ok
    so what do you advise in a situation like this please
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

  4. #4
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,258
    Post Thanks / Like
    Mentioned
    91 Post(s)
    Tagged
    5 Thread(s)

    Default Re: VLOOKUP code deleted if user types in cell

    Perhaps a macro would be able to do what you want. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do using a few examples from your data and referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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