多条件排序方法如下所示。
1:VLOOKUP函数是Excel中的一个纵向查找函数,它与LOOKUP函数和HLOOKUP函数属于一类函数,在工作中都有广泛应用。
2:如图,我们按照班级和姓名查找性别。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c995d143ad4bd1134519295b56afa40f4afb0586?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3:选中如图,键盘按Ctrl+C。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a1ec08fa513d269723a4913459fbb2fb4316d860?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4:选中如图,输入:=A1:A5&B1:B5。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f3d3572c11dfa9ecfb5ecf7e6ed0f703918fc163?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5:鼠标移到E1右下角,变成如图,按住左键往下拉。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7fd5266d01609248d573b72d80735fae6cd346c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6:选中C8,输入:=VLOOKUP(A8&B8,IF({1,0},A1:A5&B1:B5,C1:C5),2,0)即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/37d3d539b6003af39eef4509392ac65c1038b606?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7:excel用函数多条件排序方法就是这样。