Then, we use MATCH to tell Excel how many cells it should count into INDEX's range, based on a given value matched against a separate array. First, we call INDEX on a range of numbers from which we would like to look up a given value. Let's take a closer look at what's going on here. ![]() ![]() So, how do we combine INDEX and MATCH to replace VLOOKUP? We feed the MATCH function into the row_or_column argument of the INDEX function like so: = INDEX( range, MATCH( lookup_value, lookup_range, match_type))
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |