你是不是少了个MOD~~~IF((ROW(),2)=0,判定当前行号被2除后,余数为0则为真实,返回VLOOKUP,否则空白
G1=IF(MOD(ROW(),2)=0,OFFSET(G1,-1,,,),"")右拉、下拉
=IF(MOD(ROW(),2)=0,VLOOKUP(ROW()-1,G3:I205,1,0),"")