This function is used to look-up a value in a specific column and return any corresponding value.
Syntax :
=VLOOKUP(value to look for, range to look in, number of column of to return, whether exact match)
For Example:
=VLOOKUP(A1,D:E,2,FALSE)
This will search for value in A1 in column D and will return the corresponding value in column E.
VLOOKUP can also be used to compare two columns. This function can be applied to a column with more values so that it returns #N/A in the values for which it doesn't find a match for.
No comments:
Post a Comment