vlookup

[Menno]

look up value in array and return the value from another column on the same
row number where the lookup value is found in the lookup array

 

[Patrick Molloy]

thats VLOOKUP, yes, but what is the question?

 

[Jacob Skaria]

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

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

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


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
- - -
- - -
- - -
- - -

If this post helps click Yes

 

[Menno]

I want to find a value from worksheet 1;A1 in an array in worksheet2!A:B;1
and return the value from worksheet2!A:B;2 on the matching row number where
the value was found if value_ is_ true in worksheet 1;B1, and if false return
the value from A1 in B1
=IF(ISERROR(VLOOKUP(B1;worksheet2!A:B;1;FALSE));Ax;Tabelle2!A
x)

 

[Jacob Skaria]

Do you mean

=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),A1,VLOOKUP(A1,Sheet2!A:B,2,FALSE))

If this post helps click Yes