Question: how do you do vlookup 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.