![]() VLOOKUP will perform an approximate match by default, so there is technically no need to supply the 4th argument. Note: if the score is less than the first entry in the table, VLOOKUP will return the #N/A error. In other words, VLOOKUP will match the last value that is less than or equal to the lookup value. If VLOOKUP doesn't find an exact match, it will continue scanning until it finds a value greater than the lookup value, then it will "step back", and return the grade in the previous row. If it finds an exact match, it will return the grade at that row. With a score provided as a lookup value, VLOOKUP will scan the first column of the table. In approximate match mode VLOOKUP assumes the table is sorted by the first column. Finally, the last argument for VLOOKUP, the confusingly named "range lookup" is set to TRUE, to tell VLOOKUP to perform an "approximate match". The column index is provided as 2, since we want VLOOKUP to return a grade from the second column. The lookup table is the named range "key" (B5:C9). In this example, the scores in column F are lookup values for the VLOOKUP function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |