We have three columns; A with Roll Numbers
And B/C with Roll Numbers and corresponding Student Names.
Point to note is that though Column A and B contains same set of roll numbers, their sequence/order are not same.
Currently the Student Names in Column C matches the Roll Numbers of Column B.
We want the Student names populated in another column which matches the roll numbers of Column A.
- Follow via:
- RSS
- Email Alert
Question
Answers (5)
0
Votes
Too lazy to do your OWN homework eh?
nt
6th Dec
0
Votes
read your help files?
or your text book?
6th Dec
0
Votes
Vlookup
Sort the whole table alphabetically on column B, then use a vlookup(). Excel help will explain the rest.
6th Dec
0
Votes
Vlookup
I've used the lookup functions in spreadsheets and they work very well. I just needed to use Excel help a few times just to get it right.
7th Dec
0
Votes
Simple VLOOKUP
Assuming your new column is "D" and the data starts on row "2". Copy this formula into cell "D2". Then copy and past to the end of your data.
=VLOOKUP(A2,A:C,3,FALSE)
The sort of the data really makes no difference as long as each record is unique. Hope this helps.
WKCook
=VLOOKUP(A2,A:C,3,FALSE)
The sort of the data really makes no difference as long as each record is unique. Hope this helps.
WKCook
7th Dec
