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
Feb 25, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment