Feb 25, 2010

Quick Excel table join

Situation: two excel worksheets with a common id column to join on.

Use LOOKUP and VLOOKUP to do this in a simpler manner. BUSCAR y BUSCARV en castellano.

1. Copy your id column to a new worksheet
2. For each column of interest paste the formula =INDEX(SourceSheet!$A$1:$T$500;MATCH($A$3;SourceSheet!$S$1:$S$500;0);SourceColumnOfInterestNumber)

Function parameters:
INDEX(dataRange;rowNumber; columnNumber)
MATCH(targetValue;dataRange;matchType(0 for exact match))

In Spanish language version Excel:
INDICE = INDEX
COINCIDIR = MATCH

No comments:

Post a Comment