I want to use the VLOOKUP function in Excel to search for a value in a table and return a corresponding value from another column. What is the syntax for the VLOOKUP function in Excel and how do I use it to search for a value and return a corresponding value?
Shathana. S.R. Answered question
- 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.
Shathana. S.R. Answered question
Type VLOOKUP() in the formula bar and enter your lookup value in the parentheses. Enter the table array or lookup table and then enter the column index number. Then enter the range lookup.
Riya Answered question
