MS excel question

[Humberto]

Suppose one wants to match the data in column C2 to the data in column C1 as follows:

[B]C1[/B]  [B]C2[/B]

E5  R2
R2  Q2
Q2  L9
T8  V1
L9  X6
V1  A2
X6
A2

should become

[B]C1[/B]  [B]C2[/B]

E5  
R2  R2
Q2  Q2
T8  
L9  L9
V1  V1
X6  X6
A2  A2

Is there a simple way to do this? So far I've been arranging both columns alphanumerically and then used the cell command

=IF(C1=C2,"","ERROR")

on each row to detect differences, and then deleted entries as necessary. But it takes a while when you have lots of data.

So is there a simple command that matches data in the way shown above?

 

[HavocXphere]

=iferror(vlookup(A1,B:B,1,false),"")

Goes into field C1 (third column)

Drag down for all the rows.

 

[Humberto]

=iferror(vlookup(A1,B:B,1,false),"")

Goes into field C1 (third column)

Drag down for all the rows.

Wow. Thank you.

 

[Freaksta]

=iferror(vlookup(A1,B:B,1,false),"")

Goes into field C1 (third column)

Drag down for all the rows.

Ahhh auditing. The files we get from clients. Definitely enables one to develop fair excel skills.

 

[HavocXphere]

Wow. Thank you.

Glad it helped.

Ahhh auditing. The files we get from clients. Definitely enables one to develop fair excel skills.

lol - indeed.

 

[Humberto]

Even those who dislike Microsoft must surely admit: Microsoft Excel is pretty amazing.