2-D Lookup - VLOOKUP w. MATCH - Framework

Software Microsoft Excel Advanced Excel Crash Course Section 11: Lookup and Conditional Calculations
1 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.21
You save:  د.إ146.92
List Price:  A$190.56
You save:  A$54.45
List Price:  ৳11,884.34
You save:  ৳3,395.77
List Price:  CA$174.66
You save:  CA$49.90
CHF 90.53
List Price:  CHF 126.75
You save:  CHF 36.21
List Price:  kr877.41
You save:  kr250.70
List Price:  €117.96
You save:  €33.70
List Price:  £100.67
You save:  £28.76
List Price:  HK$1,088.02
You save:  HK$310.88
List Price:  ₹10,412.35
You save:  ₹2,975.17
List Price:  RM591.03
You save:  RM168.88
List Price:  ₦57,601.68
You save:  ₦16,458.80
List Price:  kr1,234.29
You save:  kr352.68
List Price:  NZ$200.72
You save:  NZ$57.35
List Price:  ₱6,999.02
You save:  ₱1,999.86
List Price:  ₨22,760.84
You save:  ₨6,503.56
List Price:  S$189.59
You save:  S$54.17
List Price:  ฿4,603.85
You save:  ฿1,315.48
List Price:  ₺1,183.47
You save:  ₺338.16
List Price:  B$729.18
You save:  B$208.35
List Price:  R2,044.87
You save:  R584.29
List Price:  Лв230.80
You save:  Лв65.94
List Price:  ₩161,258.68
You save:  ₩46,077.20
List Price:  ₪451.72
You save:  ₪129.07
Already have an account? Log In


Hi there. This is a quick recap of V lookup match combo formula. And we'll be referring to V lookup as SR formula match being the JR formula. V lookup is the one who will be focusing on the entire table array, the parameter says table array. So that's the red dotted border, which is indicating the area or the region in which we will operate. But how does match come into the picture?

Match is the one who will assist v lookup formula on one parameter that is column index number. Initially, we had to count the sequence one, two, and three which column the answer must be fetched from, but right now we have automated this using match formula. The area of operation for match formula at this moment is just the header, and we ensure that the match doesn't start from before the area of the lookup or later, it should be in sync with the header of the lookup selection. So in simple terms, the JR formula or the match formula should follow this footsteps. Have v lookup formula in terms of the boundaries and will only focus on one dimension, either header or the one portion of a column, but never both. And this moment only the header.

So this is a snapshot which will help you recollect what is the combo of the lookup match formula looks like

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.