Let’s travel together.

Hướng dẫn sử dụng Hàm VLOOKUP trong Excel (Tutorials on using for Vlookup function in excel) – WowIsee

30

Chức năng: Hàm VLOOKUP là hàm dò tìm dữ liệu theo cột, sẽ trả về giá trị của một ô nằm trên một cột nào đó nếu thỏa mãn điều kiện dò tìm.

Cú pháp: VLOOKUP(lookup_value, table_array, col_index_num, [option_lookup])

  • Lookup_value: Là giá trị dùng để dò tìm, giá trị này sẽ được dò tìm trong cột đầu tiên của bảng dữ liệu dò tìm. Giá trị dò tìm có thể là một số, một chuỗi, một công thức trả về giá trị hay một tham chiếu đến một ô nào đó dùng làm giá trị dò tìm.
  • Table_array: Là bảng dữ liệu dùng để dò tìm, bảng dò tìm có thể là tham chiếu đến một vùng nào đó hay Name trả về vùng dò tìm. Bảng dò tìm gồm có ít nhất một hàng hoặc một cột, trong đó cột thứ nhất của bảng dò tìm sẽ được dùng để dò tìm.
  • Col_index_num: Là số thứ tự của cột (tính từ trái qua phải) trong bảng dò tìm chứa giá trị mà ta muốn trả về. Col_index_num phải >=1 và <= số cột lớn nhất có trong bảng dò tìm, ngược lại hàm sẽ trả về #VALUE! hoặc #REF.
  • Option_lookup: Là tùy chọn xác định kiểu dò tìm, có 2 kiểu dò tìm:
  1. False hoặc 0: là kiểu dò tìm chính xác, hàm sẽ lấy giá trị đầu tiên mà nó tìm được trên cột đầu tiên trong bảng dò tìm. Trong trường hợp tìm không thấy, hàm sẽ trả về #N/A.
  2. True hoặc 1 hoặc để trống: là kiểu dò tìm tương đối, hàm sẽ lấy giá trị đầu tiên mà nó tìm được trên cột đầu tiên trong bảng dò tìm. Trong trường hợp tìm không thấy, nó sẽ lấy giá trị lớn nhất mà có giá trị nhỏ hơn giá trị dò tìm.

Link xem các video khác: https://www.youtube.com/channel/UCdNhaWoz0XduXIa3pIL8NiQ/videos

30 Comments
  1. erotik izle says

    If some one needs expert view concerning running a blog then i advise him/her to pay a visit this web site, Keep up the pleasant work. Kellen Berk Seta

  2. erotik says

    In the comment given above, the load current for 63.91 kW output is wrongly mentioned as 127A it is 139A. Alex Wilton Peck

  3. sikis izle says

    Very interesting details you have mentioned, regards for putting up. Carita Thaine Eldredge

    1. WowIsee says

      Thank you!

  4. erotik says

    Use and manage your capital in accordance with the ability to play that you have. Olga Dennis Juli

  5. erotik says

    Hello, its fastidious paragraph about media print, we all know media is a fantastic source of facts. Bonita Rob Nurse

    1. WowIsee says

      Hello, I dont understand what you say.

  6. sikis izle says

    The time to study or stop by the content or web pages we have linked to beneath. Larine Warner Anastasie

  7. sikis izle says

    Amazing this is very open with a precise explanation of the issues. It was truly informative. Gerti Herc Ivens

  8. erotik izle says

    You completed certain good points there. I did a search on the subject matter and found nearly all people will have the same opinion with your blog. Aidan Chevalier Olpe

  9. erotik says

    If you want to improve your familiarity only keep visiting this web site and be updated with the latest news posted here. Meghann Puff Saffier

  10. sikis izle says

    This is beyond brilliant. It stops time. She must be so proud. Dominica Killian Goldsworthy

  11. altyazili izle says

    I think this is a real great blog. Really thank you! Fantastic. Doti Prentice Kilk

  12. access says

    Hi there. I discovered your blog via Google whilst looking for a comparable topic, your website came up. It appears to be good. I have bookmarked it in my google bookmarks to come back then. Lula Yorker Sheri

  13. filmkovasi says

    After looking over a few of the blog articles on your blog, I truly like your way of blogging. I bookmarked it to my bookmark website list and will be checking back in the near future. Please check out my website as well and let me know how you feel. Eran Hillier Lukey

    1. WowIsee says

      Thank you!

  14. tek part says

    Thanks-a-mundo for the blog. Thanks Again. Keep writing. Deidre Steve Casandra

    1. WowIsee says

      Thank you! i will try do it, hope you like it.

  15. direk says

    Hi there mates, how is the whole thing, and what you would like to say regarding this post, in my view its genuinely remarkable in favor of me.| Annmarie Eric Roybn

  16. movie online says

    Great, thanks for sharing this article post. Much obliged. Rani Winifield Bernardi

  17. tek parca says

    Nice blog here! Also your web site loads up fast! What host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol Brigida Claudell Cutlerr

  18. watch says

    The following time I review a blog, I hope that it does not disappoint me as high as this set. I mean, I know it was my selection to check out, yet I really assumed youd have something interesting to state. All I hear is a bunch of yawping concerning something that you could repair if you werent as well active searching for attention. Nicola Care Kaspar

  19. dublaj says

    Sweet web site, super design and style, really clean and use genial. Gretchen Keene Armanda

  20. tek parca says

    I blog frequently and I genuinely appreciate your information. This great article has truly peaked my interest. I am going to take a note of your blog and keep checking for new details about once a week. I opted in for your Feed as well. Riki Kasper Carolina

  21. torrent says

    Greate post. Keep writing such kind of info on your blog. Im really impressed by your site. Robinia Brigg Drake

  22. bedava says

    I was wondering if you ever considered changing the layout of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or 2 pictures. Maybe you could space it out better? Idalia Roddy Kayne

  23. online says

    Good blog post. I definitely love this site. Keep writing! Sheena Vin Honor

  24. diziler says

    I blog quite often and I truly appreciate your content. Your article has truly peaked my interest. I am going to book mark your site and keep checking for new details about once a week. I subscribed to your RSS feed as well. Charlena Hubey Varrian

  25. When I initially commented I seem to have clicked on the -Notify me when new comments are added- checkbox and now every time a comment is added I receive 4 emails with the exact same comment. Is there a means you are able to remove me from that service? Cheers!

  26. Everything is very open with a really clear clarification of the issues. It was definitely informative. Your site is very helpful. Thanks for sharing!

Leave A Reply

Your email address will not be published.