优惠券號 括弧內有V 取出用户 (9554)

D2:G7 {=INDEX($A:$A,SMALL(IF(RIGHT(MID($B$2:$B$9,FIND(D$1,$B$2:$B$9),5))="V",ROW($2:$9),99),ROW(A1)))&""