lookup

潮·分享 2020-04-25 00:52

=LOOKUP(B2,{0,6,12,18,24,30,36,42,48,54,60,66,72,78,84,90,96,102,114,120},{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20})

=LOOKUP(B2,{0,6,12,18,24,30,36,42,48,54,60,66,72,78,84,90,96,102,114,120},{"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"})