IT@

vlookup٪bI\

Excel PConline IT@

vlookup٪bI\

“Lookup”֯“hS”ExcelS“Lookup”aZD~yVLOOKUPHLOOKUOLOOKUP䱳B@VLOOKUP٪u\Vlookup٪ct壹ڴhSIʨQʴktϴeڪSeGڪ䱳YʨίU

VLOOKUP(lookup_value,table_array,col_index_num , range_lookup)

g1@LOOKUP(lookup_value,table_array,col_index_num,range_lookup)t

VLOOKUP(hS壶YvSڪܵ`tϴkD觩rueialse)

g2Lookup_valueldquo;ܵ`vS@ڪ”TWΪOsi

g3Table_array ldquo;壶YvSڪܵ`rdquo;TWbC~ѫiڍѩ

range_lookup TRUEiQtable_array ڪOzISQt~VLOOKUP Ydg

Q range_lookup FALSEtable_array Yդf

zable_array ڪOMOiCZtMGѫcD

g4Col_index_num Mable_array YdD詜DS

Col_index_num 1 _QYd table_array

Col_index_num 2 _QYd table_array bPQWø

QCol_index_num 1~VLOOKUP YdL#VALUE!;

QCol_index_num Gh table_array DQ٪ VLOOKUP YdL#REF!

g5䱋ange_lookup F觩PQI٪ VLOOKUP Ydκ@kdYYkd䱳ˑGt TRUE iQtZ詜梹FQQSyGïYdlookup_value VGjQ range_value FALSE~VLOOKUP tϵï詜䱳ˑ߷SJYdL#N/A

Sueϲ

1îLZN䡲sheet1ڪBFKܵ`b sheet2 @rl쫡FKB櫡Y\L]

fӳv`heet1敪

od

=vlookup(a2,sheet1!$a$2:$f$100,6,true)

W问题V˅d

3䱨[L

xL

1Ñ߷էilںxq@Aldquo;#N/A”qηfSO

2cWldquo;RRUIT\”Y⍾էil嶡t觺r^㯼榢CfQasFdmu䱳ˑNdmuGY⍾ڪOͳOѫ@ӜcQZּg

gldquo;RRUIT\”mdash;cںͳFækʨLmdash;{“{kirdquo;—“O”—ldquo;”

GdRUIT\dd`iA\`I

dEV󀧺ͳd@觉dyd`de

公wμآ

Urp

M

aZ

`ᦼ