Category:

Course Description:

In this video I show you the answer to one of the questions that was asked some time ago on the Mr. Excel message board (the sample data was changed for the video) – The question is a complex LOOKUP problem – task is to find the header of the lookup criteria which is in a matrix. The lookup value could be in any column and any row – that’s what makes the problem complex. How to get the header based on a lookup value that could be in any cell? In the video you’ll find my approach;

Course Length: 10:43 minutes

Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.