+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP/ INDEX:MATCH part of string.

  1. #1
    Forum Contributor
    Join Date
    04-19-2013
    Location
    Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    296

    VLOOKUP/ INDEX:MATCH part of string.

    I need match some cells-

    I can do standard basic Vlookup and INDEX:MATCH but it is a bit more complex here. Essentially I have--

    In sheet1 there is:

    Colum A.........................Column B
    Codes..............................Barcode
    1234-type-Black....................123456789
    1224-blue-type.....................987654321

    In sheet2 there is:
    Colum A.........................Column B
    [I]Codes.............................[Barcode]
    bd-1224-blue
    ab-1234-black



    I need to a formula (to go in sheet2 column B) that finds a match where the numeric part of the code and colour match in the two sheets (as they codes come in slightly different formats). So it will essentially match parts of a string within cells and as a result insert the relaxant barcode into column B, sheet2.

    So in the case of the example given it would be...

    Colum A.........................Column B
    Codes..............................Barcode
    1234-type-Black....................123456789
    1224-blue-type.....................987654321

    In sheet2 there is:
    Colum A.........................Column B
    [I]Codes.............................[Barcode]
    bd-1224-blue........................987654321
    ab-1234-black.....................123456789

    Not even sure this is possible but thanks for any help in advance

    Strud

  2. #2
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: VLOOKUP/ INDEX:MATCH part of string.

    See the attached
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-19-2013
    Location
    Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    296

    Re: VLOOKUP/ INDEX:MATCH part of string.

    Massive thanks teethless mama...that's exactly what I was after!

    Gonna spend some time getting my head round it now.

    Thanks again!

    Quote Originally Posted by Teethless mama View Post
    See the attached

  4. #4
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: VLOOKUP/ INDEX:MATCH part of string.

    You're 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. How to match if cell contains some part of the string from other cells in other column?
    By kalucharan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2012, 05:40 AM
  2. [SOLVED] Search part of a string using vlookup
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-19-2012, 01:25 PM
  3. [SOLVED] VLOOKUP part of a text string
    By maheshr68 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2012, 10:32 AM
  4. Replies: 9
    Last Post: 11-22-2009, 03:04 PM
  5. Can Index & Match find a paticular part number
    By vane0326 in forum Excel General
    Replies: 0
    Last Post: 02-03-2005, 07:56 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