VLOOKUP wrong value returned- Next video in description

00:00 2 reasons Excel VLOOKUP pulling through the incorrect result
00:10 Range left blank (VLOOKUP guesstimates the answer)
00:30 Changing range to be FALSE corrects the VLOOKUP match
00:39 Purposefully using TRUE (approximate match)? Sort order critical
00:48 Alphanumeric sort orders are often the problem
00:59 Excel sorts alphanumeric lists different to a human

Some reasons Excel's VLOOKUP pulls through an answer but it is the wrong answer especially when dealing with lists that are alphanumeric.