Get a month of TabletWise Pro for free! Click here to redeem 
TabletWise.com
 

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
Copied
  Completed
You need to purchase the class to view this lesson.
One-time Purchase
$99.99
List Price:  $139.99
You save:  $40
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
A$144.05
List Price:  A$201.68
You save:  A$57.62
৳8,483.46
List Price:  ৳11,877.18
You save:  ৳3,393.72
CA$135.59
List Price:  CA$189.83
You save:  CA$54.24
CHF 94.49
List Price:  CHF 132.29
You save:  CHF 37.80
kr662.80
List Price:  kr927.95
You save:  kr265.14
€88.94
List Price:  €124.52
You save:  €35.58
£80.18
List Price:  £112.26
You save:  £32.07
HK$774.92
List Price:  HK$1,084.92
You save:  HK$310
₹7,463.22
List Price:  ₹10,448.81
You save:  ₹2,985.59
RM428.70
List Price:  RM600.20
You save:  RM171.50
₦38,796.12
List Price:  ₦54,316.12
You save:  ₦15,520
kr949.12
List Price:  kr1,328.81
You save:  kr379.68
NZ$153.04
List Price:  NZ$214.27
You save:  NZ$61.22
₱4,948.18
List Price:  ₱6,927.65
You save:  ₱1,979.47
₨16,755.82
List Price:  ₨23,458.82
You save:  ₨6,703
S$139.39
List Price:  S$195.16
You save:  S$55.76
฿3,111.68
List Price:  ฿4,356.48
You save:  ฿1,244.80
₺686.46
List Price:  ₺961.07
You save:  ₺274.61
R1,703.77
List Price:  R2,385.35
You save:  R681.57
Already have an account? Log In

Transcript

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