Questions

how to match data from three columns in an excel

+
0 Votes
Locked

how to match data from three columns in an excel

adi24jan
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.
+
1 Votes
PurpleSkys Moderator

or your text book?

+
1 Votes
gechurch

Sort the whole table alphabetically on column B, then use a vlookup(). Excel help will explain the rest.

+
1 Votes

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.

+
1 Votes
WKCook

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