vlook
 

vlook how to create

vlook
 

Refer the help ..VLOOKUP stands for vertical lookup and search for a value in
the first column of a table array and returns a value in the same row from
another column in the table array. Try the below formulas with a similar data
and try changing the name in Cell C1


ColA ColB ColC ColD ColE ColF
Name Age Sex Adam =formula1 =formula2
Adam 32 M
Marie 24 F
Francis 33 M
Joel 34 M
Susan 26 F
- - -
- - -
- - -
- - -

in place of formula1
=VLOOKUP($D$2,$A$2:$C$10,2,FALSE)

in place of formula2
=VLOOKUP($D$2,$A$2:$C$10,3,FALSE)



If this post helps click Yes
---------------
Jacob Skaria


"anjan" wrote:

vlook how to create