VLOOKUP

[Gary T]

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

 

[Sean Timmons]

Close!

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

 

[Teethless mama]

Try like this:

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