+ Reply to Thread
Results 1 to 4 of 4

VLookup function with Trim not bringing the Value, just text, Need help

  1. #1
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    VLookup function with Trim not bringing the Value, just text, Need help

    added the Vlookup formula with trim on excel cell, but some how value is not coming on cell, just formula is showing on cell,.

    =VLOOKUP(TRIM(B4),'[Master Invent Cost Table by Itemid.xlsx]Mastable'!$A$3:$H$26749,8,false)

    can some one please tell me what's wrong with formula, why its not bringing the value ?
    thanks in advance

    I have used Vlook up all the time , don't know why its not working now,

    please some one can help

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: VLookup function with Trim not bringing the Value, just text, Need help

    Hi
    Check that the cell the formula is in is not set to 'Text' format. If so, it will just show the typed formula as you describe.

    DBY

  3. #3
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: VLookup function with Trim not bringing the Value, just text, Need help

    Thanks DBY

    you were right, it was text format

    don't know why I did not look at this , that's why you guys are genius

    thanks again

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: VLookup function with Trim not bringing the Value, just text, Need help

    Thank you for the rep mark and I'll take being called genius all day long. If only it were true!

    DBY

+ 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. Text function will not TRIM!
    By Snaybot in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2014, 11:48 AM
  2. Using Vlookup on trim function error need help ASAP
    By jkthompson9011 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2014, 01:42 AM
  3. [SOLVED] Vlookup doesn't work - even with TRIM function
    By piper_co in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2013, 08:07 AM
  4. [SOLVED] I need to use VLOOKUP to trim a string of text
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-18-2012, 04:38 AM
  5. Trying to trim a trailing space char and the Trim function isn't working
    By Psychochook in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2007, 11:28 PM
  6. vlookup with trim function
    By rodgie in forum Excel General
    Replies: 4
    Last Post: 06-06-2006, 07:02 AM
  7. Replies: 3
    Last Post: 12-29-2005, 11:10 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