Excel

Question 1

What is the function of the VLOOKUP

Answer 1

The VLOOKUP function stands for vertical lookup and is used to search for specific values in columns or data sets in excel and retrieve the corresponding value in another column

Question 2

What do you need for the VLOOKUP function to work

Answer 2

1. Lookup Value
2. Table Array
3. Column Index Number
4. Range Lookup