Main Profile

At A Glance

VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmThis video is a part of VLookup Week: http://vlookupweek.wordpress.comExcel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP.In this video learn everything you need to know about VLOOKUP in 1 video.Here are the topics (minute marks jump you to that part of the video):1. VLOOKUP = V = Vertical ( min)2. Why so common? Because everyone needs to look stuff up ( 00:43 min)3. VLOOKUP Delivers a value to a cell: Extract Match ( 2:37 min)4. VLOOKUP #N/A and IFERROR or IF ( 5:25 min)5. VLOOKUP and Data Validation ( 8:10 min)6. VLOOKUP with Named Range ( 10:34 min)7. VLOOKUP as Formula Element ( 17:24 min)8. HLOOKUP = H = Horizontal ( 18:25 min)9. VLOOKUP Delivers a value to a cell: Approximate Match ( 19:40 min)10. VLOOKUP with table on different sheet ( 24:00 min)11. VLOOKUP with table in different workbook ( 25:56 min)12. Show Full Record: Numbers above column header ( 27:15 min)13. Show Full Record horizontally: COLUMNS Function ( 30:20 min)14. Show Full Record vertically: ROWS Function ( 32:28 min)15. Show Full Record: MATCH Functions ( 33:40 min)16. Two Lookup Values: Add join column as first column in table ( 35:40 min)17. Two Lookup Values: Join columns in formula and use CHOOSE function ( 38:50 min)18. Partial Text Lookup: LEFT and SEARCH Functions ( 43:22 min)19. Partial Text Lookup: MID Function ( 45:37 min)20. Partial Text Lookup: RIGHT Function ( 48:08 min)21. TRIM and VLOOKUP: Space in lookup value ( 48:57 min)22. TRIM and VLOOKUP: Space in 1st column of table ( 51:03 min)23. VLOOKUP with 3 lookup tables: CHOOSE Function ( 53:20 min)24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH ( 58:36 min)25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula ( 1:00:18 min)26. VLOOKUP and Table feature for Dynamic ranges ( 1:05:17 min)VLOOKUP Shark WEEK
Length: 01:08:03

Contact

Questions about VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

Want more info about VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question