EXCEL中嵌套函数请教 =IF((ROW(),2)=0,VLOOKUP(ROW()-1,G3:I205,1,0),"")

2025-01-24 13:54:19
推荐回答(3个)
回答1:

你是不是少了个MOD~~~IF((ROW(),2)=0,
判定当前行号被2除后,余数为0则为真实,返回VLOOKUP,否则空白

回答2:

G1
=IF(MOD(ROW(),2)=0,OFFSET(G1,-1,,,),"")
右拉、下拉

回答3:

=IF(MOD(ROW(),2)=0,VLOOKUP(ROW()-1,G3:I205,1,0),"")