WEBVTT FILE
VLOOKUP Excel

1
00:00:00.000 --> 00:00:03.000 
In this video, I show you the danger of VLOOKUP range defaults

2
00:00:03.000 --> 00:00:06.000 
If the table is sorted by the lookup value, there is no issue

3
00:00:09.000 --> 00:00:11.000 
Now I'm goint to change the order of the rows

4
00:00:23.000 --> 00:00:26.000
For the 1st row, there is no issue

5
00:00:27.500 --> 00:00:35.000
But if I lookup the value 2, it returns James and not Michael

00:00:41.000 --> 00:00:44.000
Let fix it

00:00:44.500 --> 00:00:46.000
Edit the VLOOKUP formula

00:00:48.000 --> 00:00:51.000
Set the last parameter (lookup_range) to FALSE

00:00:53.000 --> 00:00:55.000
Thanks!