Comparing Cells

[EXCEL101]

I need to perform the following function:

compare column a in sheet1 with column a in sheet2,
if there is a match then I want to pull the values from sheet 1 column b and
c to
the corresponding row in sheet2.

For instance on sheet1, cell a2 is abcd, b2 is 12345 anc c2 is 54321,
on sheet 2 cell a12 is abcd. So I would like to pull b2 and c2 from sheet 1
to sheet 2 in cells b12 and c12.

Any ideas?

 

[bj]

In sheet2 B2
enter
=if(iserror(vlookup(b2,Sheet1!A:C,2,False),"",vlookup(b2,Sheet1!A:C,2,False)
and in C2
=if(iserror(vlookup(b2,Sheet1!A:C,3,False),"",vlookup(b2,Sheet1!A:C,3,False)
and copy down as far as you need to.

 

[EXCEL101]

Tried that and am receiving a formula error.

In sheet2 B2
enter
=if(iserror(vlookup(b2,Sheet1!A:C,2,False),"",vlookup(b2,Sheet1!A:C,2,False)
and in C2
=if(iserror(vlookup(b2,Sheet1!A:C,3,False),"",vlookup(b2,Sheet1!A:C,3,False)
and copy down as far as you need to.

 

[Dave Peterson]

A small typo (in both formulas):

=if(iserror(vlookup(b2,Sheet1!A:C,2,False)),"",vlookup(b2,Sheet1!A:C,2,False))