Question: how to make a vlookup formula in excel?
Answer: 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.