That is about <vlookup>,
http://office.microsoft.com/zh-hk/excel/HP100698353076.aspx
wt can i do if the "table_array" contained
the 2 or above "lookup_value" which is the same.
then when i use the vlookup function,
it will only appear the first one,
how can the second same one exist?
I wanna ask sth about Excel
2009-06-28 7:55 pm
回答 (1)
2009-06-29 1:47 am
✔ 最佳答案
Let data place at A1:B14Lookup_value place at $E$1
F1=IF(ROW()>COUNTIF($A$1:$A$14,$E$1),"",INDEX($B:$B,SMALL(IF($A$1:$A$14=$E$1,ROW($1:$14)),ROW())))
This is array formula
you need press Shift + Ctrl + Enter, then { } will appear
please refer to the sample with the below link:
http://hk.geocities.com/andycmh2001/lookup_sth.xls
Hope that it is helpful to you
收錄日期: 2021-04-27 13:13:05
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090628000051KK00558