6 cách sử dụng hàm VLOOKUP thông minh trong Excel (cơ bản đến nâng cao) | if excel หลายเงื่อนไข

6 cách sử dụng hàm VLOOKUP thông minh trong Excel (cơ bản đến nâng cao)

ชมวิดีโอด้านล่าง

นอกจากการดูบทความนี้แล้ว คุณยังสามารถดูข้อมูลที่เป็นประโยชน์อื่นๆ อีกมากมายที่เราให้ไว้ที่นี่: ดูเพิ่มเติม

Hướng dẫn 6 cách sử dụng hàm VLOOKUP thông minh trong Excel từ cơ bản đến nâng cao.

XEM THÊM:
1. Các thủ thuật Excel hay nhất năm 2020: https://youtu.be/MDpb90pmIM0
2. Pivot Table trong Excel: https://youtu.be/7BQd_7ziKb0
3. Các hàm Excel quan trọng nhất: https://youtu.be/f0s05bTM9Eo
4. Tạo báo cáo động trong Excel (Dashboard): https://youtu.be/yjT3osvH4w
5. VBA Excel cấp tốc FULL: https://youtu.be/DT0QOoLvM10
6. Bí mật hàm Vlookup trong Excel: https://youtu.be/3FEYTVcTfGY
7. Toàn bộ các hàm Excel thông dụng: https://youtu.be/M4aX0IaaIXU
8. Hướng dẫn giải 101 bài thực hành Excel: http://bit.ly/101baiThucHanh
9. Excel nâng cao với công thức mảng: https://youtu.be/LCcTnYknAgs
10. Excel cho Kế toán cơ bản đến nâng cao: https://youtu.be/SPQetkB3p_E
11. Custom Formatting – Định dạng số trong Excel: https://youtu.be/RDKkkS4Ubrk
12. Hướng dẫn vẽ biều đồ: https://youtu.be/y8lMmXFH8ko
13. Excel cơ bản cấp tốc: https://youtu.be/k81nf5TM8rc
14. Hàm điều kiện IF từ cơ bản đến nâng cao: https://youtu.be/7gQe3B7JcRg
15. Định dạng có điều kiện Conditional Formatting: https://youtu.be/OAXQcmHJGec
16. Các lỗi thường gặp và cách khắc phục: https://youtu.be/nxIoELau_so
17. Top 25 thủ thuật nâng cao: https://youtu.be/ehYRlWmTvCg
18. Ứng dụng VBA Excel: http://bit.ly/UngDungVBA
19. Tạo Form nhập dữ liệu tự động: https://youtu.be/v6cVD_NbFcQ
20. Form quản lý khách hàng: https://youtu.be/0kz4N4wnNBc
21. Học google sheet Full: https://bit.ly/hocGoogleSheet
22. Hệ thống quản lý kho hàng hóa và mua bán: https://youtu.be/hbSogTO1aaw

Link tải file thực hành: https://bit.ly/6cach_SD_Vlookup
Đăng ký Để nhận video mới: http://bit.ly/DangKyKenhGaExcel
Contact
👉 Email: [email protected]
👉 Link Facebook: https://www.facebook.com/excelchicken
👉 Link Fanpage: https://www.facebook.com/gaexcelonline/
👉 Link Group: https://www.facebook.com/groups/2212224209065875
👉 Zalo: http://zaloapp.com/qr/p/p78wwrhhb0fh

Donate
💸 Paypal: [email protected]
💸 ViettinBank: 101871902505 Nguyễn Văn Trí

Cảm ơn các bạn đã theo dõi. Nhớ đăng ký kênh, chia sẻ để ủng hộ và cập nhật video mới nhất từ Gà Excel nhé
Chúc các bạn học tốt Excel!!!
Gaexcel \”Gà_excel ExcelChicken CungHocExcel ExcelCoBan ExcelNangCao

How to Use the NEW \u0026 IMPROVED Excel XLOOKUP (with 5 Examples)

ชมวิดีโอด้านล่าง

Excel XLOOKUP will soon become the ONLY Excel LOOKUP Function you’ll ever need to solve any lookup problem you come across. If you’d like to learn about the other brand new Excel functions like FILTER \u0026 UNIQUE check out the complete course: https://courses.xelplus.com/p/exceldynamicarrayformulas
In this video we cover 5 common Excel lookup problems:
1. Lookup returns an error (NA) This is a common problem with VLOOKUP. If the VLOOKUP function returns NA it is likely because the item you’re looking up does not exist on the lookup table. The solution so far has been to wrap the VLOOKUP function inside IFNA or IFERROR functions. With XLOOKUP however, you no longer need to do that. You just need to use the 4th argument of XLOOKUP [If_not_found] optional argument and specify the value you’d like to get back if the value does not exist on the lookup array.
2. Horizontal lookup In legacy Excel when we needed to lookup a value in a table that was structured horizontally instead of vertically we would use the HLOOKUP function. The new XLOOkUP function can do horizontal lookups as well. You just have to select the horizontal array instead of the vertical array.
3. Look for a partial match instead of an exact match in Excel: There might be times you need to look for a partial match. In this case you can combine wildcards such as the asterisk or question mark characters and combine them together with the 5th argument of XLOOKUP which is the optional [match mode] argument.
4. Two way Excel lookup: To look up a value on the rows as well as columns we generally combined VLOOKUP with Excel Match function or used the famous INDEX \u0026 MATCH functions. We no longer need to use two separate functions to do a two way lookup. We can use XLOOKUP inside another XLOOKUP to get the job done. The advantage is we just need to know one function well, instead of combining different Excel lookup functions with one another.
5. Excel approximate match lookup: There are times you’d like to look for a value inside a data table and return the closest match. This is specially used for cases where you have thresholds for example for bonus schemes. If a number falls between a specific threshold you’d like to return a corresponding value. This is where you can use XLOOKUP’s 5th argument [match mode] to look for \”exact match or next smaller item\” or \”exact match or next larger item\”.
Bookmarks:
00:00 What is Excel’s New XLOOKUP Function
01:15 Lookup Value Not Found with XLOOKUP
04:06 Horizontal Lookup with XLOOKUP in Excel
05:44 Look For Partial Match with XLOOKUP
07:51 TwoWay Lookup with XLOOKUP
10:29 Approximate Match with XLOOKUP
AVAILABILITY The XLOOKUP function is available to Office 365 users.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excelxlookup5examples
LINKS to related videos First XLOOKUP video: https://youtu.be/xnLvEhXWSas
Excel left lookup with XLOOKUP: https://youtu.be/Xz1KHEhqUCY
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe \u0026 get my TOP 10 Excel formulas ebook for free
https://www.xelplus.com/freeebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
MsExcel

การใช้ คำสั่งIF ซ้อน IF ( เงื่อนไขหลายเงื่อนไข)

ชมวิดีโอด้านล่าง

โดย วิจิตร แก้วดี

Excel พื้นฐาน 7 : การใช้ IF ร่วมกับฟังก์ชัน AND/OR

ชมวิดีโอด้านล่าง

สอนใช้ Excel ขั้นพื้นฐาน ง่ายจนคนใช้ Excel ไม่เป็นก็ดูได้ครับ
=========================
Website เทพเอ็กเซล : https://www.ThepExcel.com/
Fanpage เทพเอ็กเซล : https://www.facebook.com/ThepExcel/

สอน Excel เบื้องต้น: เปรียบเทียบการใช้ IF กับ VLOOKUP ในการตรวจสอบหลาย ๆ เงื่อนไข

ชมวิดีโอด้านล่าง

ดาวน์โหลดไฟล์ที่ใช้ในคลิปได้ที่ ► http://bit.ly/2INk4S4
เชิญสมัครเป็นสมาชิกของช่องนี้ได้ที่ ► https://www.youtube.com/subscription_center?add_user=prasertcbs
playlist สอน Excel ► https://www.youtube.com/playlist?list=PLoTScYm9O0GEMj5LpqxaxWWnanc55Epnt
playlist สอน Excel เบื้องต้น ► https://www.youtube.com/playlist?list=PLoTScYm9O0GEG_nWHhWmV0K2HsLlQ49qV
playlist สอนเทคนิคการสร้างกราฟ แผนภูมิแบบต่าง ๆ ด้วย Excel ► https://www.youtube.com/playlist?list=PLoTScYm9O0GExxZ3nlVmleu0wvlhGfs3j
playlist สอน Excel Table ► https://www.youtube.com/playlist?list=PLoTScYm9O0GERViw9rwiISMWBv8rzT1j3
playlist สอนเทคนิคการใช้งาน PowerPoint ► https://www.youtube.com/playlist?list=PLoTScYm9O0GEG5JELOjSGqigFN669d5IK
playlist สอนเทคนิคการใช้งาน Word ► https://www.youtube.com/playlist?list=PLoTScYm9O0GG5QrQtl8hmVbg0o8fCCaJT
prasertcbs_Excel prasertcbs_ExcelForBusines prasertcbs prasert_basic_excel

นอกจากการดูหัวข้อนี้แล้ว คุณยังสามารถเข้าถึงบทวิจารณ์ดีๆ อื่นๆ อีกมากมายได้ที่นี่: ดูบทความเพิ่มเติมในหมวดหมู่Wiki