The VLOOKUP function is case-insensitive so it looks up MIA or Mia or mia or miA etc. One of these functions is VLOOKUP. Its no wonder that over the years Excel users have come up with their own solutions such as an INDEX MATCH formula.
VLOOKUP This function will help to lookup data in a range or table by row.
It was created to lookup and retrieve data from a specific column in a table. The VLOOKUP and HLOOKUP functions together with INDEX and MATCH are some of the most useful functions in Excel. Below we will demonstrate how to use the CHOOSE Function instead of INDIRECT to define the lookup range. It is a very powerful lookup and reference function for looking up data.