如果您无法下载资料，请参考说明：
1、部分资料下载需要金币，请确保您的账户上有足够的金币
2、已购买过的文档，再次下载不重复扣费
3、资料包下载后请先用软件解压，在使用对应软件打开
VLOOKUPSeeAlsoSearchesforavalueintheleftmostcolumnofatable,andthenreturnsavalueinthesamerowfromacolumnyouspecifyinthetable.UseVLOOKUPinsteadofHLOOKUPwhenyourcomparisonvaluesarelocatedinacolumntotheleftofthedatayouwanttofind.TheVinVLOOKUPstandsfor"Vertical."SyntaxVLOOKUP(lookup_value,table_array,col_index_num,range_lookup)Lookup_valueisthevaluetobefoundinthefirstcolumnofthearray.Lookup_valuecanbeavalue,areference,oratextstring.Table_arrayisthetableofinformationinwhichdataislookedup.Useareferencetoarangeorarangename,suchasDatabaseorList.Ifrange_lookupisTRUE,thevaluesinthefirstcolumnoftable_arraymustbeplacedinascendingorder:...,-2,-1,0,1,2,...,A-Z,FALSE,TRUE;otherwiseVLOOKUPmaynotgivethecorrectvalue.Ifrange_lookupisFALSE,table_arraydoesnotneedtobesorted.YoucanputthevaluesinascendingorderbychoosingtheSortcommandfromtheDatamenuandselectingAscending.Thevaluesinthefirstcolumnoftable_arraycanbetext,numbers,orlogicalvalues.Uppercaseandlowercasetextareequivalent.Col_index_numisthecolumnnumberintable_arrayfromwhichthematchingvaluemustbereturned.Acol_index_numof1returnsthevalueinthefirstcolumnintable_array;acol_index_numof2returnsthevalueinthesecondcolumnintable_array,andsoon.Ifcol_index_numislessthan1,VLOOKUPreturnsthe#VALUE!errorvalue;ifcol_index_numisgreaterthanthenumberofcolumnsintable_array,VLOOKUPreturnsthe#REF!errorvalue.Range_lookupisalogicalvaluethatspecifieswhetheryouwantVLOOKUPtofindanexactmatchoranapproximatematch.IfTRUEoromitted,anapproximatematchisreturned.Inotherwords,ifanexactmatchisnotfound,thenextlargestvaluethatislessthanlookup_valueisreturned.IfFALSE,VLOOKUPwillfindanexactmatch.Ifoneisnotfound,theerrorvalue#N/Aisreturned.RemarksIfVLOOKUPcan'tfindlookup_value,andrange_lookupisTRUE,itusesthelargestvaluethatislessthanorequaltolookup_value.Iflookup_valueissmallerthanthesmallestvalueinthefirstcolumnoftable_array,VLOOKUPreturnsthe#N/Aerrorvalue.IfVLOOKUPcan'tfindlookup_value,andrange_lookupisFALSE,VLOOKUPreturnsthe#N/Avalue.ExampleTheexamplemaybeeasiertounderstand
立即下载
