excel中用变量表示单元格的例子，从当月数据表里获取当天数据或者任意一天数据

用INDIRECT函数，在原老三区表里取当天前两天的数据

=INDIRECT("原老三区"&"!"&MID("DEFGhijklmnopquvwxyz",DAY(TODAY())-2,1)&ROW())

INDIRECT("原老三区"&"!"&MID("DEFGhijklmnopqrstuvwxyzaaabacadaeafagah",IF(DAY(TODAY())<23,DAY(TODAY()),22+(DAY(TODAY())-23)*2)-2,IF(DAY(TODAY())<23,1,2))&ROW())

往前推一天

=INDIRECT("原老三区"&"!"&MID("DEFGhijklmnopqrstuvwxyzaaabacadaeafagah",IF(DAY(TODAY()-1)<23,DAY(TODAY()-1),22+(DAY(TODAY()-1)-23)*2),IF(DAY(TODAY()-1)<23,1,2))&ROW())

=INDIRECT(LEFT("aB",1)&ROW())

用if函数，取某天的数据，这个最多只能嵌套6个判断，超过6个就不行了

=IF(DAY(TODAY())=1,原老三区!D2,IF(DAY(TODAY())=2,原老三区!E2,IF(DAY(TODAY())=3,原老三区!F2,IF(DAY(TODAY())=4,原老三区!G2,IF(DAY(TODAY())=5,原老三区!H2,IF(DAY(TODAY())=6,原老三区!I2,""))))))

用LOOKUP数组，

=LOOKUP(M2,{0,1,2.5,4,6.5,8,10.5,12,14.5,16,18.5,20,22.5},{"无极","十二级","十一级","十级","九级","八级","七级","六级","五级","四级","三级","二级","一级"})