Comparing two excel files to fill a cell if there is a match

[greenmat]

Hello,

I'm trying to compare two cells from two different worksheets, if they are the same, I'd like to fill a cell with data from another cell in file A to a cell in file b. I believe this is a conditional formula, but I don't have any experience with putting a conditional formula together.

If Company name (sheet one) equals Company name A (sheet two),
then Zip (sheet two, which is empty) equals Zip (sheet one).

Thanks for the help in advance!

I've attached a file with sample data on sheet 1 and sheet 2.

[benishiryo]

hi greenmat, try this formula in Sheet2 Cell B2:
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$28,2,0)),"",VLOOKUP(A2,Sheet1!$A$2:$B$28,2,0))

if i cant find it, it will be shown as blank. otherwise, the ZIP code will show. is this what you need?

[FDibbins]

or, seeing as the OP is using 2010....

=IFerror(VLOOKUP(A2,Sheet1!$A$2:$B$28,2,0)),"")

[greenmat]

Thanks! It worked! Very much appreciate the help!