-mapleleafss(MapleLeafs) 2022-11-14

Microsoft recently announced the upcoming release of a new function called XLOOKUP. This function will be replacing the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data. Although it may have taken many years to get to this point, Excel users now have a new function that is more user-friendly, more flexible and avoids some frustrating VLOOKUP mistakes. XLOOKUP is coming... So let’s see how the XLOOKUP function works, how to use it in your Excel formu
-xjcjq(rufeng) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14

-firetrain(火车头) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14

-firetrain(火车头) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14

-jtax(吾土吾民) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14

-shiyu(鲥鱼) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-15

-guanshui3000(灌水) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14

-guanshui3000(灌水) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14
xlookup比vlookup和hlookup简单灵活，不受列和行顺序影响
-pastrychef(闪电) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14
xlookup第一个是你要找的条件，第二个是条件所在列/行，第三个是结果所在列/行，第四可以缺省，第五是条件match程度（0是绝对match）。vlookup的结果所在列一定要在条件列的后面，要指出第几列，如果两列离得远 需要数几遍，如果不巧在前面，还要移动，所以不够灵活
-pastrychef(闪电) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14

-guanshui3000(灌水) 2022-11-14

-pastrychef(闪电) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-15

-jinyinhua(金银花) 2022-11-14

-mapleleafss(MapleLeafs) 2022-11-14
once up time 用过lotus 1-2-3，觉得比excel好很多，不知道为啥就被微软干掉了
-binghongcha76(一只大猫) 2022-11-16

-mapleleafss(MapleLeafs) 2022-11-16