EXCEL如何根据填写表格时的月份不同,在下面表格呈现不同的数据?答:假设 A7输入 2022-2-1 ,标准日期格式 C9=VLOOKUP(YEAR(DATE(YEAR($A$7),MONTH($A$7)-COLUMN(A1),1)),$B$1:$AZ$4,MATCH(MONTH(DATE(YEAR($A$7),MONTH($A$7)-COLUMN(A1),1))&"月",$B$1:$AZ$1,),0)右拉公式
表格中怎么实现由表1得出表2的结果?答:在 Excel 2007 中,可用以下公式实现题述要求:=IF(RIGHT(A2,2)="V0","打开"&VLOOKUP(SUBSTITUTE(LEFT(A2,8),"C","T"),$F$2:$G$5,2),IF(RIGHT(A2,2)="VC","关闭"&VLOOKUP(SUBSTITUTE(LEFT(A2,8),"C","T"),$F$2:$G$5,2),IF(RIGHT(A2,2)="Z0",VLOOKUP(SUBSTITUTE(LEFT...