How To Use Vlookup With Match Function in Microsoft Excel

In the Formula Bar, type =VLOOKUP(). In the parentheses, enter your lookup value, followed by a comma. ... Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25, Enter column index number. ... Enter the range lookup value, either TRUE or FALSE.