+ Reply to Thread
Results 1 to 2 of 2

Vlookup/Substitute Not Replacing Values

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Vlookup/Substitute Not Replacing Values

    Hello Everyone,

    I have some code that is not working and I'm not sure why... I have a worksheet that has a list of values, however, some values I'd like to replace. Therefore, on another sheet, I made a table that contains the values and their replacements. In order to replace the values, I created a vlookup function and a substitute public sub. Here is the code:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    I've attached a test workbook so you can see that some of the values will not change. I'm sure it has something to do with changing them from general format to text.

    Thanks in advance!

    TestBook3.xlsm

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Vlookup/Substitute Not Replacing Values

    Try using:
    Please Login or Register  to view this content.
    instead of:
    Please Login or Register  to view this content.

+ 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. Substitute in a vlookup
    By cbh35711 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2015, 09:59 AM
  2. Substitute function with VLOOKUP
    By gach in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2013, 10:59 AM
  3. VLookup Substitute
    By RM1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2011, 04:03 PM
  4. VLookup Substitute
    By sabunabu in forum Excel General
    Replies: 5
    Last Post: 03-27-2008, 07:47 PM
  5. [SOLVED] VLOOKUP - WISH TO SUBSTITUTE FALSE FOR A VALUE
    By David in forum Excel General
    Replies: 6
    Last Post: 07-12-2006, 08:50 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