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

thats VLOOKUP, yes, but what is the question?

"Menno" wrote:

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

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)

"Patrick Molloy" wrote:

thats VLOOKUP, yes, but what is the question?

"Menno" wrote:

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

Do you mean

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

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


"Menno" wrote:

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)

"Patrick Molloy" wrote:

thats VLOOKUP, yes, but what is the question?

"Menno" wrote:

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

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


"Menno" wrote:

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