Try like this:

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


"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