I have a formula which use IF and VLOOKUP that refers to a linked worksheet and depending on the data in the linked worksheet will return a value or #N/A because the VLOOKUP value is not present in the linked worksheet.

I am trying to get the formula to return a 0 rather than N/A when the LOOKUP value is not present in the linked worksheet

=IF(A24="","0",(VLOOKUP(A24,'Y:\Steve\Planning\MSP''S\RED MRP\[RED MRPS JAN.xls]2005'!$1:$65536,27,FALSE)))*(VLOOKUP(A24,Costing,11,FALSE))

As you can see if the value A24 is not present in

'Y:\Steve\Planning\MSP''S\RED MRP\[RED MRPS JAN.xls]2005'

Then #N/A is returned and I need it to return a 0

Any help would be appreciated.