請幫忙解答以下問題:
Column A Column B
200000001 John
200000002 Peter
300000003 Mary
400000004 David
500000005 Paul
如果我在這個儲存格打 John, 隔離的儲存格怎樣可顯示 200000001, 如此類推.
應該用LOOKUP or IF?
謝謝
Excel Formula 問題
2011-08-15 11:42 pm
回答 (2)
2011-08-16 8:28 am
✔ 最佳答案
提供四種公式:假設在D1打 John
=INDEX(A1:A5,MATCH(D1,B1:B5,0))
=INDIRECT("A"&MATCH(D1,B1:B5,0))
=VLOOKUP(D1,IF({1,0},B1:B5,A1:A5),2,0)
=LOOKUP(1,1/(B1:B5=D1),A1:A5)
2011-08-16 6:01 am
=vlookup(b1,$a$1:$a$5,false)
b1 is John
$a$1:$a$5 is range of column A
b1 is John
$a$1:$a$5 is range of column A
收錄日期: 2021-04-13 18:10:09
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110815000051KK00688