Hi Karen,
Sure, if you are using Excel 2007 or later you can do it like this:
=IFERROR(VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0),"no match")
If you are using Excel 2003 or earlier then you can do it like this:
=IF(ISNA(VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0)),"no match",VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0))
|