Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Which function in Excel will intelligently combine tables using a common column as an index?

For example:

share|improve this question
possible duplicate of Excel: Merge two tables based on one column – Jeremy W May 30 '12 at 18:12
up vote 1 down vote accepted

1) Make a list of all the unique extensions (the "index" column)

2) Add values for the "name" column

  • Create a new column next to the extensions, with the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), where lookup_value is the extension in the new table to look up in the "names" table, table_array is the "names" table, and col_index_num is the column in the "names" table containing the names (column 2).

3) Do the same thing for the "scores" column

share|improve this answer
Alternatively, you could create a PivotTable based on Multiple Consolidation Ranges, where the two ranges are the "names" table and the "scores" table. – Excel User May 30 '12 at 18:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.