VLOOKUP Formula VLOOKUP lookup_value table_array col_index_num range_lookup To translate this to simple English the formula is saying Look for this piece of information in the following area and give me some corresponding data from another column. The formula you would enter is. You can use the COLUMN function to quickly determine the col_index_num of the VLOOKUP formula without having to count columns.
It is quite simple to operate and easy to use the Excel VLOOKUP function.
The VLOOKUP function is case-insensitive so it looks up MIA or Mia or mia or miA etc. Where VLOOKUP and HLOOKUP cant reach this formula can reach. INDEX MATCH formulas work right-to-left whereas VLOOKUP formulas only work as a left-to-right lookup. The syntax and arguments are VLOOKUP search_value lookup_table column_number approximate_match This article explains how to use the VLOOKUP function in all versions of Excel including Excel 2019 and Microsoft 365.