excel怎样把家庭成员有序的显示在户主后面？

Question

如题所述

Answer 1

表1

表2

L3=IF(INT(COLUMN(C1)/3)<VLOOKUP($D3,表1!$D:$H,5,),INDEX(表1!$I:$I,MATCH($D3,表1!$D:$D,)+INT(COLUMN(C1)/3)),"")

M3=IF(INT(COLUMN(C1)/3)<VLOOKUP($D3,表1!$D:$H,5,),INDEX(表1!$D:$D,MATCH($D3,表1!$D:$D,)+INT(COLUMN(C1)/3)),"")

N3=IF(INT(COLUMN(C1)/3)<VLOOKUP($D3,表1!$D:$H,5,),INDEX(表1!$F:$F,MATCH($D3,表1!$D:$D,)+INT(COLUMN(C1)/3)),"")

选中者三个单元格一起向下向右复制