Matching up columns in 2 diff. files

**Proxina** · 09-12-2012, 02:06 AM

Hi

Hope someone can help me with this.

In sheet 1 I have column A and B like below. (Actual values are more complex than in example below)
A B
1 a
2 b
3 c
4 d

In sheet 2 I have column A, with same information but not in the same order, and column B which needs to be filled with info from sheet 1.
A B
2
3
1
4

What I need help with is matching up the rows so they have the same information. i.e. 1->a, 2->b and so on.
(reason I dont just copy+paste is that I want to see an error if there is a spelling mistake)

-Prox

**Ace_XL** · 09-12-2012, 02:19 AM

In Sheet2

=VLOOKUP(A2,Sheet1!$A$2:$B$5,2,FALSE)
or
=INDEX(Sheet1!$B$2:$B$6,MATCH(A2,Sheet1!$A$2:$A$5,0))

Adjust ranges accordingly

**Fotis1991** · 09-12-2012, 02:22 AM

Try in b1 of sheet2 and copy down.

=IFERROR(INDEX(Sheet1!$B$1:$B$1000;MATCH(A1;Sheet1!$A$1:$A$1000;0));"")

Change the semi colons to comma if you have to do this.