"Cheers" back at you. :)
--
Briggs


"franciz" wrote:

glad I am of help. cheers,

"Briggs" wrote:

OMG-YOU'RE A GENIUS. A very PATIENT one, I might add. It works!!!!! THanks
SO MUCH for your help!!!!
--
Briggs


"franciz" wrote:

assuming that Sheet2, you have the following table

Col A Col B Col C
ID Last Name First Name
123 Briggs S
456 MS L
789 ABC XYZ

In Sheet1, assuming you have no header row, place the formula
as follow in B1 and press Enter.
This will return Briggs in B1
Copy down as far as your data is. You may need to adjust $A$1:$D$1000
according to your table

Col A Col B
123 =VLOOKUP(A1,Sheet2!$A$1:$D$1000,2,FALSE)

hope this help.

"Briggs" wrote:

That's precisely my dilemma! I don't know what to do with the formula to
give me results! I'm such a novice at this, I apologize for sounding so
dense. I have the formula in cell B1 of sheet 1. I don't know what to do
with it!!!
--
Briggs


"franciz" wrote:

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