随机取二區數據 (10373)

C2=IF($A2>0,OFFSET(H$1,RANDBETWEEN(1,COUNTA(H:H)-1),),OFFSET(K$1,RANDBETWEEN(1,COUNTA(K:K)-1),))

D2=VLOOKUP(C2,IF(B2="",H$2:I$9,K$2:L$9),2,)

另解D2=VLOOKUP(C2,OFFSET(H$1,1,IF(A2="",3,0),50,2),2,)

C2:D2區域數組 下拉{=IF($A2>0,OFFSET(H$1:I$1,RANDBETWEEN(1,COUNTA(H:H)-1),),OFFSET(K$1:L$1,RANDBETWEEN(1,COUNTA(K:K)-1),))