It seems that virtually every job these days requires knowledge of Excel. A common question or scenario that is presented at interviews (including the interview that I had for my current role) is where the prospective employee is asked to demonstrate their knowledge of VLOOKUP.

Yes I know XLOOKUP has been part of Excel since 2020 but many companies are still stuck with the older VLOOKUP

So if you’re looking for a new job or a promotion in 2023, this is a must-watch video

Introduction

VLOOKUP using FALSE as the 4th Parameter

VLOOKUP using TRUE as the 4th Parameter