excel

快速补位

="SM"&TEXT(G2,"000")
 

快速创建随机手机号

=CHOOSE(RANDBETWEEN(1,3),1515204,1589525,1390522)&TEXT(RANDBETWEEN(0,10^4-1),"0000")
 

水平查找功能

=HLOOKUP(B6,plan!B1:R36,32)

代表在数组 plan 工作表中 B1:R36 的矩阵中，第一行，水平查找 B6 的值，然后得到列之后，获取到 32 位置的值

参考： http://www.kokojia.com/article/22278.html

资料

玩转Excel的查找
参考标题：

妙用 Excel 的查找功能

VLOOKUP模糊匹配的妙用

https://blog.csdn.net/ccozkf/article/details/54922486

讲解了模糊查找，快速匹配成绩功能

excel查找函数：HLOOKUP函数运用实例

https://baijiahao.baidu.com/s?id=1617540635110766162&wfr=spider&for=pc

LOOKUP函数有三兄弟，自己，大兄VLOOKUP，小弟HLOOKUP。许多小伙伴对LOOKUP和大兄VLOOKUP熟悉，却不认识小弟HLOOKUP。若说VLOOKUP是推土机，从右往左横行，那HLOOKUP就是挖井机，从上往下啃土。两者结合，方能纵横，笑傲职场。

以 销售算案例为主 进行了展示

玩转Excel系列-hlookup函数的使用

https://blog.csdn.net/dafeilaoshi/article/details/70046219

演示了基本函数的方法

Excel | LOOKUP查询函数十种用法大集锦，快快收藏了备用！

https://mp.weixin.qq.com/s?__biz=MzIxODgwNjg2Mw==&mid=2247484335&idx=1&sn=2c2e9247bb8762848a5921b7cc308a44&chksm=97e5ac8fa0922599835fa65bd03897cd1b28cff39905362c0a3ba926619c1a9c3803ae174d6c&scene=21#wechat_redirect

Excel096 | VLOOKUP完成同一部门多个员工信息查询

https://mp.weixin.qq.com/s?__biz=MzIxODgwNjg2Mw==&mid=2247486158&idx=2&sn=d3d3602586d4bd17a18b0bce71241de6&chksm=97e5a5eea0922cf8abee1affb5e923a4cd586950013d8998a4b37a96a4330f40860f8c45d4d7&scene=21#wechat_redirect

Excel | VLOOKUP与IFERROR是好搭档

https://mp.weixin.qq.com/s?__biz=MzIxODgwNjg2Mw==&mid=2247488667&idx=2&sn=7c31697d6ae85232974c8fe821cbf603&chksm=97e5bbbba09232adbf38ace8e121d91afd02c1d5d52b17c15c07a7922d91323f8260be8028ab&scene=21#wechat_redirect

Excel290 | VLOOKUP函数实现多表数据合并查询

https://mp.weixin.qq.com/s?__biz=MzIxODgwNjg2Mw==&mid=2247487263&idx=1&sn=b3881a35e4e2c3e20b34579ff413f915&chksm=97e5a03fa09229296de3a2b4da2222e38f825c82de1f4128d9330dee051902e7a21289ce4271&scene=21#wechat_redirect

EXCEL知识树：你要的知识可以自己查找

https://mp.weixin.qq.com/s?__biz=MzIxODgwNjg2Mw==&mid=100002545&idx=1&sn=c6132df90a785a63c1a8b11842eaeceb&chksm=17e5a5d120922cc78885aa394611562ef1ef88b4c9a1c73fbf8afce74e16e28abb40da8f26ba&mpshare=1&scene=1&srcid=0421N1yPVTAcRRXDYT6y0Djv&key=da4083cb8d0ad04328ac8709b907f19f397db013a00956ea0fbaab85dd797dad6b028aa9ee605d52dfd1c44581cdee68afbe3aecb56672475bb78969da13f81a072174c0903cf779c95ce074dc72ebda&ascene=1&uin=ODA0MDA0NTgy&devicetype=Windows+10&version=62060739&lang=zh_CN&pass_ticket=8CYqsQ8%2FZ5NlPpoC0%2FcklzmsnlO1spboxDpVEh2U8zlMkXd3NYHCI7TSVdMZhkqn

Excel | VLOOKUP列查找，HLOOKUP行查找

https://mp.weixin.qq.com/s?__biz=MzIxODgwNjg2Mw==&mid=2247488614&idx=1&sn=e232379d3a5688fff6e5c6267390f5ec&chksm=97e5bb46a09232502c7f76c7fa66e09782b7c726d22dd2d6bad8f8fc015d999ed6d0d66a0a03&scene=21#wechat_redirect

Excel203 | VLOOKUP函数使用方法之小成篇——多行多列查找

https://mp.weixin.qq.com/s?__biz=MzIxODgwNjg2Mw==&mid=2247486225&idx=1&sn=6e4aa2035ec4fd9e88e6c9382b7f1a61&chksm=97e5a431a0922d2745cbce6470669783f91b52af2dbf344fda99423b04aceb4242554b15a162&scene=21#wechat_redirect