So I have a column of data that has various part numbers in. (CVS8H900b2030HILE3) for instance. I need to extract the HILE3 part and match it to a Vlookup style table to return an extended description of that part. The issue is its not always HILE3 it could be some other series of letters and it might e 1 or 2 characters more or less than the HILE3... I have a Vlookup style table with the complete list on a support tabe with the answers I want it to return. Any help would be greatly appreciated.
DD
DD