+ Reply to Thread
Results 1 to 4 of 4

Vlookup Based part of a Cell

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    usa
    MS-Off Ver
    Excel 2009
    Posts
    2

    Vlookup Based part of a Cell

    Hi,

    I am new to this site I hope that I am not posting any duplicated questions,

    I need help with the below example, I basically have in "column A" bad data that I want to get into "column B" corrected,the same as it appears in "column E".
    Is there any way I can make a Vlookup if the data is not exactly the same? Thank You!


    Capture.JPG
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Vlookup Based part of a Cell

    Try this
    Copy of Book1.xlsx
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    08-13-2013
    Location
    usa
    MS-Off Ver
    Excel 2009
    Posts
    2

    Re: Vlookup Based part of a Cell

    Amazing, Thank You!

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Vlookup Based part of a Cell

    You are welcome

+ 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. Only use part of a cell value for vlookup
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-27-2010, 10:27 AM
  2. Vlookup Part of Cell
    By VegasL in forum Excel General
    Replies: 4
    Last Post: 01-05-2010, 10:05 PM
  3. VLOOKUP only part of a cell
    By [email protected] in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2008, 03:59 PM
  4. VLOOKUP on Part of a Cell?
    By Sepia in forum Excel General
    Replies: 3
    Last Post: 08-08-2007, 07:14 AM
  5. [SOLVED] VLOOKUP based on PART of another cell's text
    By djDaemon in forum Excel General
    Replies: 0
    Last Post: 03-09-2006, 09:15 AM

Tags for this Thread

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