+ Reply to Thread
Results 1 to 2 of 2

vlookup to find a value and replace

  1. #1
    Registered User
    Join Date
    03-02-2014
    Location
    Italy - Martinsicuro
    MS-Off Ver
    Excel 2019
    Posts
    3

    vlookup to find a value and replace

    Hi, this is my first post here. Hope is in the right place

    I want to use vlookup to find value from Cell "E43" in column(B20:B39), and replace the value
    (adding 1 to the value that exists) in the corrisponding row, column (C20:C39) for a number of times
    (value in cell "D41"). If value in the cell "D41"=0 do nothing. The initial values in the column ("C20:C39") are zeroes(0).

    When The number in the column (C20:C39) change, the value in the cell "E43" changes also and writes that value
    from the cell "B42" down until cell "B500"

    That's the code i'm using to do all the stuff except replacing values in the column ("C20:C39"). I'm doing it manualy
    In the attached file the value in ("E43") does not change because I used only a sheet from the original file.

    Please Login or Register  to view this content.
    Thanks for your observation Pepe Le Mokko.
    Done
    Attached Files Attached Files
    Last edited by BlackDaniels; 12-26-2015 at 01:08 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: vlookup to find a value and replace

    Ciao
    please wrap code with code tags as per forum rules. Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  2. [SOLVED] VLOOKUP to Find and Replace for entire workbook
    By HeatherAngelo in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-13-2014, 03:23 PM
  3. find with vlookup and replace the value
    By memrah in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-05-2012, 12:39 PM
  4. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  5. Vlookup find and replace
    By nicolaforni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2011, 07:21 AM
  6. Help with find and replace formula or vlookup?
    By brooksc29 in forum Excel General
    Replies: 1
    Last Post: 08-11-2010, 10:10 PM
  7. [SOLVED] Find & Replace / Loop & Vlookup
    By thom hoyle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2005, 08:05 PM

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