In this video I explain one of the short-comings of the VLOOKUP function and how to get around the problem using the MATCH function. The example I use is creating a school timetable however the content of the video is relevant to every Excel user.
In this video I explain one of the short-comings of the VLOOKUP function and how to get around the problem using the MATCH function. The example I use is creating a school timetable however the content of the video is relevant to every Excel user.