![💢](https://www.facebook.com/images/emoji.php/v9/tfb/3/16/1f4a2.png)
![😅](https://www.facebook.com/images/emoji.php/v9/t91/3/16/1f605.png)
EP24 Excel lookup formulas #สูตรlookup
![🙋♀️](https://www.facebook.com/images/emoji.php/v9/t68/3/16/1f64b_200d_2640.png)
![👨💻](https://www.facebook.com/images/emoji.php/v9/t1b/3/16/1f468_200d_1f4bb.png)
![⛔️](https://www.facebook.com/images/emoji.php/v9/tbf/3/16/26d4.png)
![⛔️](https://www.facebook.com/images/emoji.php/v9/tbf/3/16/26d4.png)
![⛔️](https://www.facebook.com/images/emoji.php/v9/tbf/3/16/26d4.png)
![⛔️](https://www.facebook.com/images/emoji.php/v9/tbf/3/16/26d4.png)
![⛔️](https://www.facebook.com/images/emoji.php/v9/tbf/3/16/26d4.png)
สุดท้ายแล้ว เอาไว้ก่อนนานมาก เป็นปีๆ กว่าจะแง้ม กลับมาดูสูตรนี้อีกที ![😆](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNiIgaGVpZ2h0PSIxNiIgdmlld0JveD0iMCAwIDE2IDE2Ij48cmVjdCB3aWR0aD0iMTAwJSIgaGVpZ2h0PSIxMDAlIiBzdHlsZT0iZmlsbDojY2ZkNGRiO2ZpbGwtb3BhY2l0eTogMC4xOyIvPjwvc3ZnPg==)
![😆](https://www.facebook.com/images/emoji.php/v9/t12/3/16/1f606.png)
![📌](https://www.facebook.com/images/emoji.php/v9/tea/3/16/1f4cc.png)
EP นี้ใช้เวลาเขียนนานที่สุดเท่าที่เคยเขียนมา เพราะแอดอยากทำสิ่งที่ Beginners คิดว่าซับซ้อน ให้มันดูง่ายที่สุดเท่าที่จะทำได้
และไหนๆ สายหวานจะทำเรื่อง lookup ทั้งที เราจะธรรมดาไม่ได้ เราต้องขนมาสอนให้หมดทั้ง 4 สูตรของ lookup จะได้เปรียบเทียบ และเข้าใจความแตกต่างของแต่ละสูตร ไม่ต้องไปนั่งไล่หาดูทีละบทความ โดยจะเริ่มตั้งแต่สูตรที่สั้นที่สุดไล่ไปถึงสูตรขั้นสุดของตระกูล lookup ซึ่งมีดังนี้
![🟢](https://www.facebook.com/images/emoji.php/v9/t3a/3/16/1f7e2.png)
![🟢](https://www.facebook.com/images/emoji.php/v9/t3a/3/16/1f7e2.png)
![🟢](https://www.facebook.com/images/emoji.php/v9/t3a/3/16/1f7e2.png)
![🟢](https://www.facebook.com/images/emoji.php/v9/t3a/3/16/1f7e2.png)
เพื่อให้เห็นภาพชัดเจนยิ่งขึ้น EP นี้มี ตัวอย่างง่ายๆ ให้ดูมากกว่า 20 ตัวอย่าง
ใครพร้อมลุยแล้วก็อย่าได้รอช้า เข้าไปลองศึกษา lookup กันได้เลยจ้า
![vlookup excel](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-1-min.png)
![EP.24 4 LOOKUP formulas 2-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-2-min.png)
![EP.24 4 LOOKUP formulas 3-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-3-min.png)
![EP.24 4 LOOKUP formulas 4-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-4-min.png)
![EP.24 4 LOOKUP formulas 5-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-5-min.png)
![EP.24 4 LOOKUP formulas 6-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-6-min.png)
![EP.24 4 LOOKUP formulas 7-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-7-min.png)
![EP.24 4 LOOKUP formulas 8-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-8-min.png)
![EP.24 4 LOOKUP formulas 9-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-9-min.png)
![EP.24 4 LOOKUP formulas 10-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-10-min.png)
![EP.24 4 LOOKUP formulas 11-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-11-min.png)
![EP.24 4 LOOKUP formulas 12-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-12-min.png)
![vlookup excel](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-13-min.png)
![EP.24 4 LOOKUP formulas 14-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-14-min.png)
![EP.24 4 LOOKUP formulas 15-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-15-min.png)
![EP.24 4 LOOKUP formulas 16-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-16-min.png)
![EP.24 4 LOOKUP formulas 17-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-17-min.png)
![EP.24 4 LOOKUP formulas 18-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-18-min.png)
![EP.24 4 LOOKUP formulas 19-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-19-min.png)
![EP.24 4 LOOKUP formulas 20-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-20-min.png)
![EP.24 4 LOOKUP formulas 21-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-21-min.png)
![EP.24 4 LOOKUP formulas 22-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-22-min.png)
![EP.24 4 LOOKUP formulas 23-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-23-min.png)
![EP.24 4 LOOKUP formulas 24-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-24-min.png)
![EP.24 4 LOOKUP formulas 25-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-25-min.png)
![EP.24 4 LOOKUP formulas 26-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-26-min.png)
![EP.24 4 LOOKUP formulas 27-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-27-min.png)
![EP.24 4 LOOKUP formulas 28-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-28-min.png)
![EP.24 4 LOOKUP formulas 29-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-29-min.png)
![EP.24 4 LOOKUP formulas 30-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-30-min.png)
![EP.24 4 LOOKUP formulas 31-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-31-min.png)
![vlookup excel](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-32-min.png)
![EP.24 4 LOOKUP formulas 33-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-33-min.png)
![EP.24 4 LOOKUP formulas 34-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-34-min.png)
![EP.24 4 LOOKUP formulas 35-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-35-min.png)
![EP.24 4 LOOKUP formulas 36-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-36-min.png)
![EP.24 4 LOOKUP formulas 37-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-37-min.png)
![EP.24 4 LOOKUP formulas 38-min](https://sweet-excel.com/wp-content/uploads/2021/08/EP.24-4-LOOUP-formulas-38-min.png)
![EP.24 4 LOOUP formulas Done](https://sweet-excel.com/wp-content/uploads/2020/11/EP.24-4-LOOUP-formulas-Done.png)
Responses