This VLOOKUP tutorial walks you through the top 5 mistakes and how to fix them. VLOOKUP is one of Excel’s most powerful formulas but it can produce errors if you do not follow the proper syntax. This video shows you how to fix VLOOKUP #N/A errors as well as the #REF and #NAME errors.
Timestamps:
0:00 Intro
0:13 VLOOKUP #N/A extra space
1:01 VLOOKUP #N/A missing value
1:47 VLOOKUP #N/A left to right
2:25 VLOOKUP #N/A absolute reference
3:03 VLOOKUP #NAME and #REF
3:36 Bonus
3:54 Thank you
📈 Free Download Link to practice Excel workbook from video
1drv.ms/x/s!Ak3WDHJodVlziGp1G...
🔔 Subscribe to my channel
bit.ly/2QCjwXg
👍 If you learned something please give this video a thumbs up
8 авг 2024