the formula doesn't merge the 2 sheets together, it return the value in a table
corresponding to the lookup value.
the formula should return the last name in B1. What is the result you get?


"Briggs" wrote:

Thanks! I put the formula in cell B1 of Sheet 1, but how do I merge sheet 2
into sheet 1 to come up with the results? The way it is right now, Sheet1
has the ID only in column A, and the VLOOKUP formula in cell B1. Sheet2 has
the ID in column A and the student last name in column B, and student first
name in column C.
--
Briggs


"franciz" wrote:

Assuming that you have ID only on Sheet1 and student's name and ID on Sheet2,
place Shane's formula in cell B1 of Sheet1. ie beside cell A1 which you have
the ID.

hope this help

xlmate

"Briggs" wrote:

Thanks, Shane, but I'm not quite sure what cell I am putting this formula in.
Is it possible to be more specific? Thanks!
--
Briggs


"ShaneDevenshire" wrote:

Hi,

Try

VLOOKUP(A1,Sheet2!$A$1:$D$1000,2,FALSE)

where A1 is in the sheet with the ID's only and is the first ID, the range
on Sheet2 from A1:D1000 is your student info range, your's will be different.
ID must be in the first column of this sheet. The 2 tells Excel to return
the info from the second column - that might be First Name. You might change
this to 3 if the Last Name was in the third column of the table A1:D1000 .

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire


"Briggs" wrote:

I have two spreadsheets that I need to merge. One has the student's name and
ID number, and the other one only has the ID number. Is there a way to merge
the two sheets so that the ID number is matched up with the student name?
The sheet with the ID numbers only involves over 5,000; the sheet with the
name and ID number is under 600.
--
Briggs