+ Reply to Thread
Results 1 to 5 of 5

VLOOKUP only part of a cell

  1. 07-23-2008, 03:24 PM #1
    [email protected]
    hutch@edge.net is offline
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706

    VLOOKUP only part of a cell

    Hi again.

    Suppose I have a hundreds of part number like this:
    AC1000130

    The number 1000 in the above part number represents a sub-group that I need to vlookup.

    If the part number is in cell A2, and the name of the table I am searching is "sub_group", how would I perform a vlookup?

    Thanks in advance.

    Hutch
    Reply With QuoteRegister To Reply
  2. 07-23-2008, 03:32 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Best to post a sample if you want a proper answer

    Here's guess one

    Please Login or Register  to view this content.
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  3. 07-23-2008, 03:46 PM #3
    [email protected]
    hutch@edge.net is offline
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706
    That worked perfectly, Noob.

    Here's the formula, as used:
    Please Login or Register  to view this content.
    One question... what does the +0 do?

    Thanks for the help!
    Reply With QuoteRegister To Reply
  4. 07-23-2008, 03:49 PM #4
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Excel reads
    =MID(A2,3,4)
    as text. By adding the zero it changes it back to a number

    VBA Noob
    Reply With QuoteRegister To Reply
  5. 07-23-2008, 03:59 PM #5
    [email protected]
    hutch@edge.net is offline
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706
    Aha! Makes sense.

    Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1