Follow via:
RSS
Email Alert
Question
0 Votes

# how to match data from three columns in an excel

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.
Tags: windows
6th Dec

## Answers (5)

0 Votes
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
7th Dec
###### Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
• [b] Bold [/b]
• [i] Italic [/i]
• [u] Underline [/u]
• [s] Strikethrough [/s]
• [q] "Quote" [/q]
• [ol][*] 1. Ordered List [/ol]
• [ul][*] · Unordered List [/ul]
• [pre] Preformat [/pre]
• [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.