VLOOKUP is one of the most used functions in Excel. Almost anyone who has used Excel for a certain number of years would have heard of VLOOKUP and has likely written one or two.
This function is often considered a benchmark in a user’s Excel development – that moment when they step into the intermediate level of Excel formula skills. I will never forget the days when I was first learning VLOOKUP – a wild mixture of confusion, fun, and excitement.
In recent years, with the development of the new array engine in Excel (Chapter ...
