Ace that Excel Interview with VLOOKUP. How to pass the VLOOKUP Interview Test

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

For full details see the timestamps below:

⏱ Timestamps
00:00:00 Introduction
00:01:31 VLOOKUP using FALSE as the 4th Parameter
00:06:58 VLOOKUP using TRUE as the 4th Parameter

Be the first to comment