วิธีใช้ฟังชั่น VLOOKUP พร้อมเคสการใช้งานจริง (จากเริ่มต้นจนถึงระดับเทพ!!)

#googlesheets #googlesheetstips #vlookup How to use the VLOOKUP function with real-world use cases, starting from basic to advanced. Today's video will focus on the VLOOKUP formula, which is likely the most frequently used function. I personally use this function mostly to create templates in the worksheet. It's a very useful function and can be used in many different situations. Today, I'll explain how to use this function from the beginning. We'll start with simple methods to advanced methods. In addition, there will be real-world use cases as examples in each section. 00:00 - Beginning 01:09 - How to understand how each formula is written and used 01:47 - What exactly is the VLOOKUP formula? 02:45 - How to use a basic VLOOKUP 04:38 - Using VLOOKUP with a sales system 07:11 - How to use the IFERROR formula to prevent #N/A 07:53 - Using the VLOOKUP formula to get all the data just by typing it once 09:14 - VLOOKUP without specifying which column you want the data from 11:08 - Using VLOOKUP to calculate student grades 13:05 - Using VLOOKUP when product prices vary by quantity 14:11 - Using VLOOKUP to calculate commissions 15:32 - Conclusion 🎥 Equipment I used: Sony ZV-E10 camera kit 16-50mm: (https://shope.ee/5KeppTetsX) Logitech MX Master 3s Mouse: (https://shope.ee/8UbraALvKD) Logitech G502 Hero Mouse: (https://shope.ee/99rYOea8Z9) MacBook Air M2: (https://shope.ee/qCQTd8LuD) Saramonic Blink 500 Wireless Microphone: (https://shope.ee/2feGcpazuj) ------------------------------------------------ Management Like an IT Person FB Page:   / managewithnoobitguy   Line OA: https://lin.ee/4HxwEJi YouTube Channel:    / การการแบบคนไอที   Website: https://noobitguy.one/ Email: [email protected] -----------------------------------------------