Part3 - LOOKUP Series - Lookup Numbers stored as Text

This Video is Part3 of the Lookup series from my Live virtual Training Sessions.
In the part1 & 2 we had learnt the basics of VLOOKUP function and also the usage of approximate match and now In this video we are going to look at a solution for one common problem in VLookup when we use this function to Lookup numbers which are stored as text. There are different approaches to solve this and the one which I am showing you in this video, I feel is best of all.

Time Line:

00:53 - Look at the problem first
02:30 - What is the problem
03:27 - What is the solution
03:50 - Explanation of Value function
04:13 - Using Value function within VLookup

Please watch the previous videos of the series for better understanding of this video and

Following is the Link to access all the videos of the series

https://youtube.com/playlist?list=PLBOqy5dc7CHUcEZ0rDk-_KTma5KVdC7Bj

Find the link of practice file/files which I have used in this video https://drive.google.com/drive/folders/1V-oJWhdCIqsJrg2udLpy7nH3_ijw3X6H?usp=sharing

Видео Part3 - LOOKUP Series - Lookup Numbers stored as Text канала ExcelisMagical - Shakeel