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