柚子快报邀请码778899分享: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
柚子快报邀请码778899分享:excel
发表评论