What does the VLOOKUP function do in Excel?
1
It looks vertically down the first column of a range for a key and returns the value of a specified cell in the row found
2
It calculates the average of a range of cells
3
It replaces specific text in a text string
4
It divides the contents of one cell from another