![]() It is commonly used along with the MATCH function, Where the combination of INDEX & MATCH function is an alternate option for the VLOOKUP function, which is more powerful & flexible.To look up a value of cell where an intersection of the row and column happens.INDEX function in Excel helps you out to find out the value within a data set range, where it can look up values by both column & row. ![]() Excel functions, formula, charts, formatting creating excel dashboard & others
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |