Excel 2016 – 3.7.3 – How VLOOKUP Can Go Wrong

If you require a LOOKUP function to look for something specific, then you must use the Range_lookup box. This video will show you what can happen if you don’t use it – and explain what is going on.

Previous

Excel 2016 - 3.7.2 - Create a VLOOKUP
Next

Excel 2016 - 3.7.4 - Create a VLOOKUP That Doesn't Require an Exact Result