Page 432 - Excel 2013 All-in-One For Dummies
P. 432
414 Lookup and Reference
Figure 6-3:
Doing a two-way lookup
in the Production Schedule table.
To look up the number of the part scheduled to be produced in a particular month, you need to the use the MATCH function, which returns the rela- tive position of a particular value in a cell range or array. The syntax of the MATCH function is as follows:
MATCH(lookup_value,lookup_array,[match_type])
The lookup_value argument is, of course, the value whose position you want returned when a match is found, and the lookup_array is the cell range or array containing the values that you want to match. The optional match_type argument is the number 1, 0, or –1, which specifies how Excel matches the value specified by the lookup_value argument in the range specified by the lookup_array argument:
✦ Usematch_type1tofindthelargestvaluethatislessthanorequaltothe lookup_value. Note that the values in the lookup_array must be placed in ascending order when you use the 1 match_type argument. (Excel uses this type of matching when the match_type argument is omitted from the MATCH function.)
