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.

Input and Output

lookup

Share

You may also like...