When To Use Index
For those of you who are well-versed in Excel, you are most likely very familiar with the VLOOKUP function. The VLOOKUP function is used to find a value in a different cell based on some matching text within the same row. As powerful as it is, VLOOKUP has a limitation on how the matching reference table needs to be structured in order for the formula to work. This article will show you the limitation where VLOOKUP cannot be used and introduce another function in Excel called INDEX-MATCH that can solve the issue....