如何使用Vlookup()函数制作“地址标签”

How to Make the Address Label by Using Function of Vlookup()

讲述了电子表格 EXCEL的 Vlookup()函数的功能 ,使用该函数实现了由“地址一览表”生成“信封标签”的过程和注意事项以及对该例子稍作变动可用于其它许多实用场合。

This paper presents the functions of EXCEL Vlookup() function,and the procedures of generating the envelop address label by a address schedule with the function and points to be paid attentions.This example can be used to some other occasions after it is changed a little.