Hi all I could use some help with a Vlookup.

I have a range name of 'rng' on sheet A.
Column A
1
2
3
4
5
6

In a different file I have a range name 'table'
Column A Column B
1 20
3 5
4 7
6 13

My problem is with a vlookup since certain numbers don't exist in 'table' it
returns a #N/A so I end up with.

Column A Column B
1 20
2 #N/A
3 5
4 7
5 #N/A
6 13

Is there a way to return a '0' instead of #N/A on a vlookup so I can still
sum Column B? Thanks for any help in advance.