I looking to compare data on two sheets, the student's ID number and spit back their homeroom.
Screen Shot 2015-02-06 at 4.36.47 PM.pngScreen Shot 2015-02-06 at 4.36.33 PM.png
I looking to compare data on two sheets, the student's ID number and spit back their homeroom.
Screen Shot 2015-02-06 at 4.36.47 PM.pngScreen Shot 2015-02-06 at 4.36.33 PM.png
I would probably concatenate columns A&B on both tabs then use vlookup to keep things simple.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I did that and am still getting the #REF! error:
=VLOOKUP(A2,Sheet2!A:A,3,TRUE)
I edited it to this: =VLOOKUP(B2,Sheet2!A1:C778,3,FALSE)
but now get the #N/A error
Can you post sample data?
Wait, is the "Number" unique for each person? If so you can simply do the vlookup off of that.
in cell d2 of sheet 1 (assuming sheet 1 is on the left):Please Login or Register to view this content.
Last edited by mikeTRON; 02-06-2015 at 06:50 PM.
I can't because the data is sensitive. Sorry.
That worked! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks