Thaum twg los xij koj taug qab txhua yam nrog daim ntawv teev npe, yuav muaj ib lub sijhawm thaum koj xav nrhiav cov ntaub ntawv yam tsis tas yuav xaub los ntawm cov npe. Tias yog thaum LOOKUP muaj nuj nqi tuaj yeem pab tau.
Cia peb hais tias koj muaj cov npe yooj yim ntawm 1000 tus neeg siv khoom nrog peb kab ntawv: lub xeem, tus xov tooj, thiab hnub nyoog. Yog tias koj xav nrhiav tus lej xov tooj rau Monique Wikihow, koj tuaj yeem saib txhua lub npe hauv kab ntawv ntawd kom txog thaum koj pom nws. Txhawm rau kom nrawm dua, koj tuaj yeem txheeb cov npe ntawm tus tsiaj ntawv, tab sis yog tias koj muaj ntau tus neeg siv khoom nrog lub xeem lub npe pib nrog "w", koj tseem tuaj yeem mob taub hau tshawb cov npe. Kev siv LOOKUP muaj nuj nqi, txawm li cas los xij, koj tuaj yeem sau lub npe yooj yim thiab daim ntawv nthuav tawm yuav ntuav Miss wikiHow tus xov tooj thiab hnub nyoog. Suab zoo, tsis yog nws?
Cov kauj ruam
Kauj Ruam 1. Tsim ob kab npe rau hauv qab ntawm nplooj ntawv
Hauv qhov piv txwv no, ib kem muaj tus lej thiab lwm qhov muaj cov lus tsis raug.
Kauj Ruam 2. Txiav txim siab ntawm tes uas koj xav kom tus neeg siv xaiv los ntawm, qhov no yog qhov uas cov npe teev cia yuav yog
Kauj Ruam 3. Thaum koj nyem rau ntawm tes, ciam teb yuav tsum tsaus, xaiv DATA tab ntawm lub cuab yeej, tom qab ntawd xaiv VALIDATION
Kauj Ruam 4. Lub popup yuav tsum tshwm, hauv ALLOW list pick LIST
Kauj Ruam 5. Tam sim no xaiv koj qhov chaw, ua lwm yam lus koj thawj kab ntawv, xaiv lub pob nrog tus xub liab
Kauj Ruam 6. Xaiv thawj kab ntawm koj daim ntawv thiab nyem nkag mus thiab nyem OK thaum cov ntaub ntawv lees paub qhov rai tshwm, tam sim no koj yuav tsum pom lub npov uas muaj tus xub pom, yog tias koj nyem rau ntawm nws koj cov npe yuav tsum poob
Kauj Ruam 7. Xaiv lwm lub thawv uas koj xav kom lwm cov ntaub ntawv nthuav tawm
Kauj Ruam 8. Thaum koj nyem lub thawv ntawd, mus rau INSERT tab thiab FUNCTION
Kauj Ruam 9. Thaum lub thawv tshwm tuaj, xaiv LOOKUP & REFERENCE los ntawm cov npe pawg
Kauj Ruam 10. Nrhiav LOOKUP hauv cov npe thiab ob-nias rau nws, lwm lub thawv yuav tsum tshwm nyem nyem OK
Kauj Ruam 11. Rau qhov lookup_value xaiv lub xovtooj nrog cov npe sau cia
Kauj Ruam 12. Rau Lookup_vector xaiv thawj kab ntawm koj daim ntawv teev npe
Kauj Ruam 13. Rau Qhov Result_vector xaiv kab thib ob
Kauj Ruam 14. Tam sim no thaum twg koj xaiv qee yam los ntawm cov npe teev cia cov ntaub ntawv yuav tsum hloov pauv
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Nco ntsoov thaum koj nyob hauv DATA VALIDATION window (Kauj Ruam 5) lub thawv ntawv sau IN-CELL DROPDOWN tau tshuaj xyuas
- Thaum twg koj ua tiav koj tuaj yeem hloov xim font mus rau dawb, kom cov npe zais.
- Txuag koj cov haujlwm tas li, tshwj xeeb tshaj yog tias cov npe muaj ntau
- yog tias koj xav sau yam koj xav tshawb nrhiav koj tuaj yeem hla mus rau qib 7
