懂Excel人员要匹配两个字段通常会使用lookup函数,lookup函数可以解决简单匹配功能,如果要进行复杂匹配就需要与其它函数进行搭配.对于办公人员来说估计算是不小麻烦.该软件(software)根据日常办公人员需要进行研究,使用界面化操作,除了能去除多余空格转换相同格式进行匹配,还能在不同文档中灵活匹配,更重要是能让您字段按照须要提取部分进行匹配(即条件匹配).有兴越朋友可以下载用用,它是一款二十几K大小纯绿色软件(software),只为方便工作而开发,不过好像不适合XP系统,最好配置是win2000+office2003

Know Excel personnel to want to match two fields to be able to use Lookup function normally, lookup function can be solved match a function simply, if should undertake complex match to undertake collocation with respect to need and other function. To office staff estimation is not little trouble. This software needs to undertake study according to daily office staff, use interface turns an operation, besides can surplus blank space changes purify to undertake matching with the format, still can match neatly in different documentation, heavier if can let your field according to must want to extract a part to undertake matching (namely the condition matchs) . Have promote jump over a friend to be able to download with, it is software of pure green of size of a two K, develop for convenient job only, seem not to suit XP system nevertheless, best configuration is Win2000+office2003