Thaum cov ntaub ntawv hauv koj daim ntawv ua haujlwm Excel npog ntau pua kab thiab kaum ob kab, siv HLOOKUP muaj nuj nqi txhawm rau nrhiav tus nqi teev hauv kab ntawv teev tseg.
Cov lus qhia hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, thiab Excel 2013.
How the HLOOKUP Function Works
HLOOKUP muaj nuj nqi yog hom kev tshawb nrhiav. Qhov kev ua haujlwm no tshawb nrhiav cov ntaub ntawv tshwj xeeb hauv daim ntawv ua haujlwm los ntawm thawj zaug nrhiav tus nqi teev nyob rau hauv kab ntawv thiab nrhiav kab ntawv rau tus nqi sib xws.
Lub HLOOKUP muaj nuj nqi yog qhov zoo tshaj plaws rau cov ntawv ua haujlwm nrog cov ntaub ntawv loj. Qhov piv txwv no siv daim ntawv ua haujlwm yooj yim los qhia tias HLOOKUP txoj haujlwm ua haujlwm li cas.
Nyob rau hauv daim ntawv no, tus neeg muag khoom taug qab kev muag khoom los ntawm cov khoom thiab los ntawm cov channel uas txhua yam khoom muag. Hloov chaw ntawm kev tshawb nrhiav daim ntawv ua haujlwm kom pom kev muag online rau cov koob yees duab, piv txwv li, HLOOKUP muaj peev xwm ua tau haujlwm.
Syntax of the HLOOKUP Function
Tus syntax ntawm HLOOKUP muaj nuj nqi yog:
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)
Ntawm no yog qhov kev sib cav ua li cas hauv HLOOKUP muaj nuj nqi:
- lookup_value (yuav tsum tau): Cov kab yuav tsum tau tshawb nrhiav. HLOOKUP muaj nuj nqi tshawb thawj kab kom pom tus nqi no. Qhov kev sib cav no tuaj yeem yog kev siv xovtooj ntawm tes lossis kab ntawv kab lus.
- table_array (yuav tsum tau): Lub rooj yuav tsum tau tshawb nrhiav cov ntaub ntawv teev tseg. Qhov no tuaj yeem yog qhov siv rau ntau yam lossis ntau lub npe.
- row_index_num (yuav tsum tau): Tus lej ntawm kab uas Excel yuav rov qab cov ntaub ntawv.
- range_lookup (optional): Qhov kev sib cav no qhia HLOOKUP muaj nuj nqi yuav ua li cas yog tias nws tsis pom qhov sib tw. Cov ntsiab lus sib cav yog TRUE thiab FALSE.
- Yog tias tus nqi yog qhov tseeb thiab cov ntaub ntawv cov lus tau txheeb los ntawm qhov tsawg tshaj plaws mus rau qhov loj tshaj plaws, HLOOKUP rov qab tus nqi loj tshaj plaws uas me dua qhov kev sib cav lookup_value.
- Yog tus nqi yog FALSE, HLOOKUP muaj nuj nqi rov qab ua yuam kev yog tias tsis pom qhov sib tw tiag tiag.
Yuav Siv HLOOKUP hauv Excel
piv txwv no siv HLOOKUP muaj nuj nqi los nrhiav kev muag online rau cov koob yees duab. Nov yog yuav ua li cas nkag mus rau cov qauv hauv daim ntawv ua haujlwm:
- Nkag mus rau cov ntaub ntawv ua haujlwm, tom qab ntawd teeb tsa cov npe kab hauv kab nce mus.
-
Xaiv lub xovtooj uas yuav tso tawm qhov tshwm sim ntawm HLOOKUP muaj nuj nqi.
Image -
Select Formulas > Lookup & Reference > HLOOKUP.
Image - In the Function Arguments dialog box, tso tus cursor rau hauv Lookup_value text box.
-
Hauv daim ntawv ua haujlwm, xaiv lub xov tooj ntawm tes uas muaj tus nqi koj xav pom nyob rau hauv kab saum toj kawg nkaus ntawm cov ntaub ntawv.
Image Siv lub xov tooj siv yog tias koj xav tshawb nrhiav qhov sib txawv. Txhawm rau tshawb nrhiav tus nqi sib txawv, sau lub npe sib txawv hauv lub xov tooj.
- In the Function Arguments dialog box, tso tus cursor rau hauv Table_array text box.
-
Hauv daim ntawv ua haujlwm, xaiv cov ntaub ntawv koj xav tshawb. Hauv qhov piv txwv no, tag nrho cov ntaub ntawv raug xaiv.
Image -
In the Function Arguments dialog box, tso tus cursor rau hauv Row_index_num ntawv lub thawv thiab sau tus lej ntawm kab uas muaj cov qhov koj xav tau.
Qhov no tsis yog tus lej kab uas tshwm hauv Excel daim ntawv. Tus lej no yog kab nyob rau hauv cov array xaiv.
-
Xaiv OK.
Image -
Lub HLOOKUP muaj nuj nqi tshawb thawj kab kom pom qhov lookup_value, thiab tom qab ntawd nws tshawb nrhiav kab ntawv kom pom tus nqi teev. Tus nqi tshwm nyob rau hauv lub cell xaiv.
Image
Yuav siv cov ntawv cim nrog HLOOKUP
Thaum koj tsis paub cov ntawv tseeb lossis kab npe koj xav tau, siv daim ntawv cim nrog HLOOKUP. Cov no yog cov wildcards uas koj tuaj yeem siv hauv Excel los ua cov ntawv tshawb nrhiav:
- Asterisk (): Siv los qhia tias tsawg kawg ib tsab ntawv ploj los ntawm lub sijhawm tshawb nrhiav. Piv txwv li, thaum tshawb nrhiav ib yam khoom thiab koj tsis paub meej tias lub npe yog Lub Koob Yees Duab, Lub Koob Yees Duab, lossis Lub Koob Yees Duab & Video, nkag mus Camera.
- nqe lus nug (?): Siv los qhia tias tsuas yog ib tsab ntawv uas ploj lawm los ntawm kev tshawb nrhiav. Piv txwv li, thaum tshawb nrhiav tus neeg siv khoom thiab koj tsis paub meej tias lub npe yog Petersen lossis Peterson, sau Peters?n.
Ntxiv cov ntaub ntawv ntau npaum li koj tuaj yeem ua tau rau kev tshawb nrhiav tsiaj qus. Excel tsuas yog rov qab ib qho kev sib tw thiab tsis qhia tias muaj ntau qhov sib tw.
