Greetings all. I know the answer is here, but I can not get this to work.
On sheet 1 I have col A "ID" and col B "Name" which are data input columns.
On sheet 2 I have col A "ID" and col B "Name" which is the name of the person
corresponding to the ID on the same row in col A, and is to be used as my
lookup table. The values on sheet 2 are contained in the range A1:B15. What
I want is for the persons name to autopopulate on sheet 1 col B when I input
the ID in col A. I am confused by the syntax of VLOOKUP. Thank you for the
help.

Greg

Try this,

=VLOOKUP(A2,Sheet1!A$1:B$15,2,FALSE)

Mike

"Greg Snidow" wrote:

Greetings all. I know the answer is here, but I can not get this to work.
On sheet 1 I have col A "ID" and col B "Name" which are data input columns.
On sheet 2 I have col A "ID" and col B "Name" which is the name of the person
corresponding to the ID on the same row in col A, and is to be used as my
lookup table. The values on sheet 2 are contained in the range A1:B15. What
I want is for the persons name to autopopulate on sheet 1 col B when I input
the ID in col A. I am confused by the syntax of VLOOKUP. Thank you for the
help.

Greg

Thanks for the quick reply Mike. I kept fiddling with it after I posted, and
got it to return always 0. The only way I could get it to work is by naming
the lookup range then referencing the name in the formula rather than the
range. Strange, but it works now. Thanks.

"Mike H" wrote:

Try this,

=VLOOKUP(A2,Sheet1!A$1:B$15,2,FALSE)

Mike

"Greg Snidow" wrote:

Greetings all. I know the answer is here, but I can not get this to work.
On sheet 1 I have col A "ID" and col B "Name" which are data input columns.
On sheet 2 I have col A "ID" and col B "Name" which is the name of the person
corresponding to the ID on the same row in col A, and is to be used as my
lookup table. The values on sheet 2 are contained in the range A1:B15. What
I want is for the persons name to autopopulate on sheet 1 col B when I input
the ID in col A. I am confused by the syntax of VLOOKUP. Thank you for the
help.

Greg