Question Locked

how to match data from three columns in an excel

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

6 replies

by gechurch

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

by gclifton_banned1234567891

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.

by 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

This discussion is closed to new replies.