VLOOKUP problem

[MSP]

First post here! I operate in Excel 2007.

I have a problem with a spreadsheet that has three tabs. In Sheet1 is the first set of values and in Sheet2 is the second set of values. My boss wants me to make a third tab which pulls items from both sheets.

He wants is so that any items from Sheet2 that AREN'T on Sheet1 are listed in the 3rd sheet. If they ARE listed on Sheet1, it returns a blank space. I can get it to return a blank space but every other value it pulls (In other words, values that are not on both sheets) returns a N/A instead of the value itself.

Attached is the spreadsheet with just the values. Here is the formula I use in the 3rd tab to pull the info:

=IF(VLOOKUP(Sheet2!$A3,Sheet1!$A$1:$A$1044,1,FALSE),"",Sheet2!$A3)

Do I just use regular lookup or MATCH instead of VLOOKUP because I'm only searching one array? Could that be the problem?

EDIT: I attached the wrong spreadsheet.

[zbor]

Here, try this:

=IF(ISNA(MATCH(Sheet2!$A3,Sheet1!$A$1:$A$1044,0)),"",Sheet2!$A3)

[MSP]

Here, try this:

=IF(ISNA(MATCH(Sheet2!$A3,Sheet1!$A$1:$A$1044,0)),"",Sheet2!$A3)

Exactly what I was looking for. Thank you!

From the looks of things, this was a two-part process that needed a conversion from N/A to the actual number.