Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

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.