The VLOOKUP function only looks to the right. Note: the formula correctly looks up the salary of MIA Reed, not Mia Clark. However, you can use INDEX, MATCH and EXACT in Excel to perform a case-sensitive lookup. For example, use INDEX and MATCH in Excel to perform a two-way-lookup.īy default, the VLOOKUP function performs a case-insensitive lookup. The INDEX function can also return a specific value in a two-dimensional range.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |