Let’s face it – many Excel users are reluctant to learn the Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX) because they think that they are complicated. And they are … until you use them a few times.
Let me show you a very simple way to find the cell value in any “intersection” of Column and Row. There are only two steps:
1) Create Named Ranges for the data in your Columns and Rows
2) Use the “Intersection Operator” – The SPACE – e.g. =Region_2 Week_16
The SPACE between Region_ 2 and Week_16 tells Excel to lookup the INTERSECTION of the Named Ranges in the formula.
It is that simple. In the video, see the equivalent formula that uses MATCH() and INDEX() – to produce the “Same Result!”
I invite you to visit my website to view all of my Excel Video Lessons – www.thecompanyrocks.com/excels
I do welcome your questions. I will try to create a video response to answer them.
And, I offer coaching, and instructional services to help you improve your proficiency in Excel. Email me for details.
Duration : 0:4:35