Hi EF,
Having not much experience with excel, would request someone to help me
I have two sheets, Sheet2 contains
- Student name
- Roll number
- Age
Sheet1 contains Roll numbers in random order.
Now, I would like to compare every roll number from Sheet1 with the column of Roll numbers in Sheet2, then find the student's name , age of the corresponding roll number and write this data in Sheet1 adjacent to the roll number.
Hope to have explained in understandable manner.
Regards
Bookmarks