Vlookup function in Microsoft Excel
Returns a value either from a one-row or one-column range or from an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.).
Syntax
=LOOKUP(<value to be searched>,<search in range>,<result print range>)
Example
In this example we have range of search data from A1:A6 and data adjacent to these values are represented by B1:B6. The formula will be displayed as green with the function applied as :
=LOOKUP(36,A1:A6,B1:B6)
this means : search data item 36, in range A1 to A6, and display corresponding values from B1 to B6
Here for 36 corresponding value is green, so green is displayed.