![]() Are you performing a range lookup? For us, the answer is yes (or “TRUE” in VLOOKUP terms). range_lookup> This is a logical value question, so the answer is either true or false.In our example, this is column B, but since the VLOOKUP command requires a number, it’s column 2. col_index_num: This is the column number where the results will be placed.For us, this is the table containing the scores and associated grades ( range D2:E7). table_array: This is often referred to unofficially as the lookup table.For us, this is the score in column A, starting with cell A2. lookup_value: This is the value for which you are looking.In that formula, the variables work like this: ![]() Before we get into applying the formula to our example, let’s have a quick reminder of the VLOOKUP syntax: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |