請教EXCEL達人~VLOOKUP函數如何傳回多個數值? - Yahoo!奇摩 ...

B1公式 =MID(PHONETIC(OFFSET(Sheet1!$B$1,MATCH(A1,Sheet1!A:A,0)-1,, COUNTIF(Sheet1!A:A,A1),2)),1 ...

tw.knowledge.yahoo.com