Summed vlookup na error replace with 0

[KBarnard01]

Goodday
I have Product with Order data in worksheet 1 which i have summed in a sum(vookup) in worksheet 2 - how can I replace the NA errors that will still SUM the orders of Product in Worksheet 1 with the summed results in Worksheet 2.
my current formula: =SUM(VLOOKUP(A2,'Incoming Containers Jhb'!$A$2:$J$585,5,FALSE))
i have tried inserting an IFERROR before the SUM(VLOOKUP) but it reports back "Too Many Arguments".

[oeldere]

Try this one.

=iferror(SUM(VLOOKUP(A2,'Incoming Containers Jhb'!$A$2:$J$585,5,FALSE)),"")

[KBarnard01]

Awesome thank you so much your solution has worked. thank you for the prompt feedback.

[oeldere]

Thanks for the rep.

Glad I could help.

If you are satisfied with the solution, please mark the question solved.