VLOOKUP

G

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
 
S

Sean Timmons

Close!

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