Excel VLOOKUP not working - try this

preview_player
Показать описание
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

🔔 Subscribe to my channel

👍 If you learned something please give this video a thumbs up
Рекомендации по теме
Комментарии
Автор

I can't thank you enough. I was nearly in tears. Thank you!

luizakulchetscki
Автор

I desperately need this video! I have experienced all of these errors

carlynicolay
Автор

LEN and TRIM functions - I'll use these for lots of work thanks!

kevinschroder
Автор

on my system while xlookup working properly on his system at same file.
# value error is showing on my system

SyedAdnanAbbas-mz
Автор

Did you know that the “V” in ‘Vlookup’ stands for “Vertical”? #funfact

KyleSorenti