※ 文章网址: 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,