※ 文章網址: https://www.ptt.cc/bbs/Office/M.1427087441.A.10D.html
軟體: EXCEL
版本: 2010
A B C D
1 Name Ext. ID LOOKUP:
2 Jack 1001 0001 Jack
3 Mary 1002 0002
4 Jack 1003 0003 Result:
5 David 1004 0004 1003
VLOOKUP(D2,A1:C5,2,FALSE)=1001
→ soyoso: http://goo.gl/Il1bm4 試試，如ID是排序下，應可用lookup 03/23 13:25
==soyoso原版(無標題列)==
A B C D E
1 Jack 1001 0001 Jack
2 Jack 1002 0005
3 Jack 1003 0003 Result: Result:
4 David 1004 0004 1002 1003
[未排序，找ID最大]
D4為=INDEX(B:B,MATCH(TEXT(MAX(IF(A1:A100=D1,