This video explains the 5 reasons why Vlookup does not give you the expected result.
Time Stamp :-
00:00 - Introduction
00:30 - Reason 1 : Extra Space
01:25 - Reason 2 : Format Difference
02:05 - Reason 3 : Hidden Decimal numbers
02:55 - Reason 4 : Unlocked Reference/lookup Array
03:40 - Reason 5 : Duplicates in Lookup Array
Links for Other videos:
Vlookup ( • Excel | VLOOKUP | INDEX MATCH | Excel... )
How to Convert Text to Numbers ( • Convert Text to Number | Convert Numb... )
Telegram Channel Name : Josh Jagath
Facebook Page Name : Josh Jagath