【工作记录】Xlookup用于合并单元格
给区域经理匹配还比较方便,省经理、大区经理用xlookup就搞不定。
用VBA解决
Function ylookup(lookup_value As Variant, lookup_array As Range, return_array As Range, Optional match_mode As Variant, Optional search_mode As Variant) As Variant |
用法:
如果 a1:a10
是合并单元格,ylookup
调用a:10。
评论