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
Collapse -

or your text book?

+
1 Votes
gechurch
Collapse -

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

+
1 Votes
Collapse -

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
Collapse -

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