数据 優先提取 (10153)

C1{=VLOOKUP(A1,G:I,MIN(IF((H$1:I$5<>"")*(G$1:G$5=A1),{2,3})),)

另解=IF(VLOOKUP(A1,G:I,2,),VLOOKUP(A1,G:I,2,),VLOOKUP(A1,G:I,3,))

另解=IFERROR(1/VLOOKUP(A1,G:I,2,)^-1,VLOOKUP(A1,G:I,3,))

另解=VLOOKUP(A1,G:I,3-(VLOOKUP(A1,G:I,2,)>0),)

另解=IFERROR(1/(1/VLOOKUP(A1,G:H,2,)),VLOOKUP(A1,G:I,3,))