Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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: http://s10.postimage.org/8dwh1agfd/superuser.png

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .