Lookup Function - Needs to give 0 when cannot find, HELP

Hi

I have 2 sheets in one workbook on Excel 2010.

I want the sheet to look up the code in column A and match it in the spreadsheet 2 and then return a result in a column.

The formula i have now works apart from, when it does not match or find the code, it just gives me a random numbr returned like 3000!? Here is the lookup formula below.

How do i sort the formula so it then gives me a 0 if the code from Products!C441 is not found in Current Stock'!A$3:A$5558?

=LOOKUP(Products!C441,'Current Stock'!A$3:A$5558,'Current Stock'!J$3:J$5558)

Thank you, that one did work. However.. I have 3 columns doing the same type of thing. I copied it to the second column and changed what i thought i should and it did not work.

Here is what it had

=LOOKUP(Products!C442,'Current Stock'!A$3:A$5558,'Current Stock'!K$3:K$5558)

I changed after your post to

=IFERROR(VLOOKUP(Products!C442,'Current Stock'!A$3:K$5558,10,FALSE),0)

What am i doing wrong!?

Seriously smart! Thanks so much, i have been trying to figure it out for hours! Thanks so much