代號類似 查詢項目 (13916)

C2{=VLOOKUP("A"&B2&"A",IF({1,0},"A"&F$2:F$8&"A",G$2:G$8),2,)

另解C2=LOOKUP(1,0/("A"&B2&"A"="A"&F$2:F$8&"A"),G$2:G$8)