Close!

=IF(ISERROR(VLOOKUP($B13,Sheet2!$A$2:$A$298,3)),0, VLOOKUP($B13,Sheet2!$A$2:$A$298,3))

"Gary T" wrote:

I'm trying to find exact matches from Sheet 1 to Sheet 2, and to show a zero
value if there is no match. Can't seem to get the formula right...

=IFERROR(VLOOKUP($B13,Sheet2!$A$2:$A$298,3),0)

Any ideas?
Thanks