Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
similar text matches vlookup
hi,
does anyone have a clue how to use the vlookup or some similar function to find and show approximate text,number match? there are 2 columns for example: 1. 2. ch-223 ch223 67/a23 67-a23 I am just trying to find also similar matches, because I have a large workbook contain a couple of thousands items, which sometimes differ only in - or / sign, but the vlookup (false) function, of course, tells me that it didn't find it. I want to find it and show it or higlight that row, so I can then manually check the difference and correct it, if possible. It's a matter of 2 workbooks that came from 2 different companies, where they have obviously used some other signs for some products, so I have a bit of a problem now with linking these 2 workbooks. Thanks. Tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
similar text matches vlookup
tomaz. wrote... hi, does anyone have a clue how to use the vlookup or some similar function to find and show approximate text,number match? there are 2 columns for example: 1. 2. ch-223 ch223 67/a23 67-a23 I am just trying to find also similar matches, because I have a large workbook contain a couple of thousands items, which sometimes differ only in - or / sign, but the vlookup (false) function, of course, tells me that it didn't find it. I want to find it and show it or higlight that row, so I can then manually check the difference and correct it, if possible. It's a matter of 2 workbooks that came from 2 different companies, where they have obviously used some other signs for some products, so I have a bit of a problem now with linking these 2 workbooks. Thanks. Tom Hi! Why not just use EditReplace and remove all the "-" and "/" then they should all match. Select the range of cells in question Goto EditReplace Find what: - Replace with: nothing, leave this empty Replace All Repeat the process for the "/". Biff |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
similar text matches vlookup
Hi Tom,
Google for examples with regular expressions (regex) and Excel / VBA. HTH, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup not returning full field value (text) | Excel Worksheet Functions | |||
VLOOKUP based on PART of another cell's text | Excel Discussion (Misc queries) | |||
Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
Vlookup on multiple similar entries / NO VBA | Excel Worksheet Functions | |||
VLOOKUP first numerical value (not text) | Excel Worksheet Functions |