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 |
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 |